Forum Discussion
timesheet with multiple in/out breaks, regular hours plus over time
Hi, I'm revising a timecard to include 2 breaks. User records time in and out, in, out, in, out, in out. Regular hours, then anything over 8 is overtime. I apologize in advance for not using correct ...
=IF((((D10-C10)+(F10-E10)+(H10-G10))*24)>8,8,((D10-C10)+(F10-E10)+(H10-G10))*24)
I only changed the cell reference in red from E10 to G10 and it works in my sheet.
thank you!!!! my eyes were going crossed trying to find the mistake. I appreciate your quick reply so much. Have a wonderful day.