Timesheet Calculator
A week of in/out times → hours and gross pay, overnight-safe.
The formula behind it
daily hours = (end − start) − break • weekly gross = rate × regular + rate × multiplier × OT- start/end
- clock-in and clock-out per day; end before start counts as overnight
- threshold
- weekly hours where overtime begins
Enter each day's clock times and break; the sheet totals daily and weekly hours, handles overnight shifts as spanning midnight, then applies your overtime threshold and multiplier for gross pay. Invalid times like 99:00 are rejected rather than silently producing nonsense.
How to use this calculator
- 1
For each day worked, enter clock-in, clock-out and unpaid break minutes.
- 2
Enter your rate, weekly OT threshold and multiplier.
- 3
Read daily hours, the weekly total and gross pay.
Worked examples
Three shifts, one overnight
Mon–Wed 9–5 with breaks plus Fri 22:00→06:00 → 23 h total; overnight day shows 8 h and the total gross follows your OT rules.
One 8.75-hour Monday with a 45-minute break
09:00–17:30 minus 45 minutes = 7.75 paid hours → $170.50 at $22/h, all regular because the 40-hour overtime threshold is untouched.