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 15 minutes or 30 minutes break. I don't want to be messing about putting break time in and out as they all go at different times, would just be easier to minus 15 mins or 30 mins from total work hours. Is this possible?
2 Replies
Assuming your clock-in clock-outs are standard Excel time values, subtracting 1/96 will reduce the hours worked by a quarter hour or 1/48 for the longer break. Since I name everything, I would finish with something like
= hoursWorked - halfHour or even = SUM(hoursWorked) - 5*quarterHourLet'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.
