Adding up a week of shifts by hand goes wrong in two familiar places: a night shift that crosses midnight, and the moment hours and minutes get treated as decimals. This page does both correctly and shows the week in each form, so a payroll figure can be checked against a clock reading.

How to use it

1. 1 Type start and end times as 24-hour clock, like 09:00 and 17:30.
2. 2 Put unpaid breaks in minutes; leave the box empty if there were none.
3. 3 Add an hourly rate if you want the pay figure too.

Seven hours thirty is 7.5, not 7.30

Payroll runs on decimal hours, but a clock counts in sixties. Thirty minutes is half an hour, so it becomes .5; fifteen minutes becomes .25 and twenty minutes becomes .33. Typing the clock reading straight into a spreadsheet is the most common way a timesheet loses money.

A shift past midnight is not a negative shift

From 22:00 to 06:00 is eight hours, but plain subtraction gives minus sixteen. Turning that into zero hides the shift, and taking the absolute value pays sixteen hours for eight. Here an end time earlier than the start is read as the following day, which is what the roster meant.

Which breaks come out of the total

Only unpaid ones. In many places a short rest break stays paid while a longer meal break does not, and the threshold is set by law or by contract rather than by habit. Put the unpaid minutes in the break column and leave paid ones out; that keeps the total honest either way.

The threshold flags overtime, it does not price it

Overtime multipliers differ by country, by contract and sometimes by which day the hours fell on, so this page shows you how many hours sit above your threshold and leaves the rate to you. The gross figure uses your plain hourly rate for every hour worked.