About the Timesheet Calculator
Adding hours by hand goes wrong because clock times are base sixty and money is base ten. This page does the conversion for every line: worked = (clock out minus clock in) minus unpaid break, kept in whole minutes, then divided by sixty to give the decimal hours that payroll systems expect. A shift of 09:00 to 17:30 with a thirty minute break is 480 minutes, printed as 8h 00m and as 8.00 hours.
Write one shift per line as a label, a start, an end and an optional break, for example Tue 08:45 17:15 45. Twelve hour times such as 9:00am are understood, breaks may be written as minutes, as 0:30 or as 45m, and a clock out that is earlier than the clock in is treated as a night shift that finishes the next day, which is why the Thursday line in the sample counts eight hours across midnight and is marked with a plus.
Rounding follows the conventions payroll actually uses: nearest six minutes gives tenths of an hour, nearest fifteen gives quarters, and each shift is rounded before the week is totalled rather than after. Anything above the overtime threshold, forty hours by default, is priced at the multiplier you set. Set the hourly rate to zero and the pay section disappears, leaving only hours. For the gap between two dates rather than two clock times, use the date difference calculator, and duration formatter converts a total of minutes into other units.
How to use
- Enter one shift per line as label start end break, such as Mon 09:00 17:30 30.
- Choose a rounding rule if your employer rounds to quarter hours or tenths.
- Set your hourly rate and the overtime threshold in the toolbar.
- Read the per day table, then the weekly totals and gross pay underneath.
Common questions
- How do I enter a night shift that ends after midnight?
- Write it normally, such as 22:00 06:30. An end time earlier than the start is taken as the following day and the row is marked with a plus sign.
- Why does 7 hours 45 minutes show as 7.75?
- Payroll works in decimal hours, so minutes are divided by sixty. Forty five minutes is three quarters of an hour, which is 0.75.
- Are breaks paid or unpaid?
- The break column is treated as unpaid and subtracted from the shift. Leave it off any line where the break is paid.
- How is overtime worked out?
- Hours above the threshold for the whole list are paid at the multiplier, so 42.75 hours with a forty hour threshold gives 2.75 overtime hours at 1.5 times the rate.