Timesheet in Excel

March 24, 2009 at 10:06:56
Specs: Windows XP
I am creating a timesheet for overnight employees. I have developed the following formula:
=IF((IF(F13<C13, F13+1-C13, F13-C13)*24)>8,8,IF(F13<C13, F13+1-C13, F13-C13)*24)

where F13 is end time and C13 is start time. (Leaving room for expansion, we currently pay for lunches)

The following formula was my original (with the lunch break included) but would not calculate the overnight hours properly:


Can anyone simplify this formula for me? There must be an easier way! I'd love to use the same formula across the entire workbook.

See More: Timesheet in Excel

Report •

March 25, 2009 at 08:11:12
not sure it's much simpler but...


Will work out even with lunch breaks and times across the night. This assumes no one is working more than 24 hour days, and there's a max of 8 hours a day (think that's what your original formula was doing)

Report •
Related Solutions

Ask Question