Weekly Timesheet Calculator
Enter each day's start and finish. Breaks come off every worked day, night shifts crossing midnight are handled, and anything past the threshold is paid at time and a half.
Total hours
40.00hours
- Total hours
- 40.00
- Monday
- 8.00 h
- Tuesday
- 8.00 h
- Wednesday
- 8.00 h
- Thursday
- 8.50 h
- Friday
- 7.50 h
- Basic pay
- $880.00
- Overtime
- $0.00
- Total pay
- $880.00
- The break is deducted from every day that has hours on it. A shift running past midnight is handled — 22:00 to 06:00 counts as eight hours rather than as a negative.
- Round consistently or not at all. Rounding each day to the nearest quarter hour and then adding them up gives a different answer from adding first, and over a year the difference is real money.
About the timesheet calculator
Adding up a week of clock times is arithmetic that is easy to get slightly wrong and tedious to do repeatedly. Nine to five-thirty less a thirty-minute break is eight hours; five of those is a forty-hour week; and a day that runs half an hour long pushes you into overtime that is easily missed.
The case that catches naive subtraction is a shift crossing midnight. Ten at night to six in the morning is eight hours, and subtracting 22 from 6 gives minus sixteen. Any night shift entered here is treated as ending the following day.
Rounding is worth a word. If you round each day to the nearest quarter hour and then add them up, you get a different answer from adding first and rounding once — and across a year the difference is real money. Pick one convention and hold to it. In many jurisdictions rounding is only lawful if it is neutral over time rather than always in the employer's favour.
The break is deducted from every day that has hours on it. If your breaks vary by day, adjust the finish times instead — it comes to the same thing and is quicker than running the calculator several times.
What it works out
- Seven days of clock-in and clock-out times
- A break deducted from each worked day
- Night shifts crossing midnight
- Overtime past a weekly threshold, and total pay
The formula
Day hours = (Finish − Start − Break) ÷ 60 Week = sum, then overtime past the threshold
Everything is converted to minutes from midnight, subtracted, and divided back into hours. Nine o'clock is 540 minutes, half past five is 1,050, and the difference less a 30-minute break is 480 — eight hours.
Where a finish time is at or before the start, the shift is treated as ending the next day and 24 hours are added. Ten at night to six in the morning becomes 1,320 to 1,800, which is eight hours rather than minus sixteen.
The week in the example comes to 40 hours exactly: three days of eight, one of eight and a half, one of seven and a half. At $22 that is $880 with no overtime.
Push Friday to six and the week becomes 41 hours — $880 of basic plus one hour at $33, or $913. The threshold applies to the week's total rather than to any individual day, which is the usual arrangement but not universal.
- Start, Finish
- Clock times in 24-hour format. A finish before the start means a night shift.
- Break
- Minutes, deducted from every day that has hours on it.
- Threshold
- Weekly hours before overtime, paid here at time and a half.
A worked example
A week of nine to five-thirty with a half-hour break, finishing at six on Thursday and five on Friday, at $22 an hour.
That works out to 40.00 hours.
- Total hours
- 40.00
- Monday
- 8.00 h
- Tuesday
- 8.00 h
- Wednesday
- 8.00 h
- Thursday
- 8.50 h
- Friday
- 7.50 h
- Basic pay
- $880.00
- Overtime
- $0.00
- Total pay
- $880.00
Questions
How do I calculate hours worked from clock times?
Subtract the start from the finish and take off the break. Nine to five-thirty less thirty minutes is eight hours. Enter the week above and it adds them up.
How do I handle a night shift?
Enter it normally — 22:00 to 06:00. A finish at or before the start is treated as the next day, giving eight hours rather than the minus sixteen that plain subtraction produces.
Are unpaid breaks deducted?
Yes, from every day with hours on it. If your breaks vary by day, adjust the finish times instead — it comes to the same total and is quicker.
Should I round to the nearest quarter hour?
Pick one convention and hold to it, because rounding each day and then adding gives a different answer from adding first. In many places rounding is only lawful if it is neutral over time rather than always favouring the employer.
Is overtime by day or by week?
This applies it to the weekly total, which is the usual arrangement. Some jurisdictions also require overtime past eight hours in a single day regardless of the week — check your own rules.
How do I convert minutes to decimal hours?
Divide by 60. Thirty minutes is 0.5 hours, fifteen is 0.25, ten is 0.167. Payroll systems work in decimal hours, which is why a 7:30 finish shows as 7.5 rather than 7.30.
What time format should I use?
24-hour, as 09:00 or 17:30. It removes any ambiguity about morning and afternoon, which matters most for exactly the night shifts that are easiest to get wrong.