Forum Discussion
Adding a length of break time column to a timesheet
Hi guys, I'm trying to create a fairly simple time sheet, I have columns for time in and time out, I'd like to add a column to add break length to the time sheet, so each team member will have either ...
Let's say Time In is in B2, Time Out in C2 and Break Time in D2.
Time Worked is given by =MOD(C2-B2,1)-D2
This will work even for night shifts crossing midnight, and it can be filled down.