Hello, I am creating a timesheet for work. It shows start time, End Time, Break Length and total hours per day. Each heading has a drop down menu, times from 00:00 to 24:00, I can work this formula out =SUM(A2-A1-A3)*24. However this is where I get confused, in the drop down list for times I have also added AL which if selected, should give the value 8 in A3, PAT which if selected should give the value 8 in A3, SICK which if selected, should give the value 0 in A3, AUTH AB which if selected, should give the value 0 in A3, UNAUTH AB which if selected, should give the value 0 in A3 and OTHER which if selected, should give the value 0 in A3. The original hours calculation formula should also be an alternative. Any help would be much appreciated!