|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.