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