Timecard hours
Subtract a start time from a finish time, then remove an unpaid break. This sample covers a 09:15 to 17:45 shift with a 45-minute break.
| @1 | startTime = 09:15 | |
| @2 | finishTime = 17:45 | |
| @3 | breakTime = 45 min | |
| @4 | shiftLength = finishTime - startTime | |
| @5 | paidTime = shiftLength - breakTime |
How it works
- Edit the start and finish times in 24-hour notation.
- Set
breakTimeto the unpaid duration. - Use
paidTimefor the hours that remain after the break.
Add another calculator group for an overnight shift, or keep one shift per group when you are checking a weekly timesheet.