How timesheet hours are added up
Each day is worked out on its own and the days are then added. Because an hour has 60 minutes, not 100, the safest way is to work in minutes and convert once at the end.
Hours worked = end time − start time − unpaid break
Decimal hours = total minutes ÷ 60
Gross pay = total minutes ÷ 60 × hourly rate
The start and end are clock times, the unpaid break is the part of the shift you are not paid for, and the hourly rate is your pay per hour before tax. If the end time is earlier than the start time, the shift ran past midnight, so 24 hours are added before subtracting.
Worked example: a five-day week
Suppose the week looks like this, with breaks in minutes.
| Day | Start | End | Break | Worked |
|---|---|---|---|---|
| Monday | 8:30 am | 5:15 pm | 45 | 8:00 |
| Tuesday | 8:30 am | 5:00 pm | 30 | 8:00 |
| Wednesday | 9:00 am | 5:20 pm | 60 | 7:20 |
| Thursday | 10:00 pm | 6:00 am | 30 | 7:30 |
| Friday | 8:30 am | 12:30 pm | 0 | 4:00 |
- An ordinary day. On Wednesday, 9:00 am to 5:20 pm is 8 hours 20 minutes, or 500 minutes. Take off the 60-minute break: 440 minutes, which is 7:20.
- An overnight shift. On Thursday, 10:00 pm to 6:00 am crosses midnight. Two hours to midnight plus six after it is 8 hours, or 480 minutes. Less the 30-minute break, that is 450 minutes, or 7:30.
- Add the minutes. 480 + 480 + 440 + 450 + 240 = 2,090 minutes.
- Convert. 2,090 ÷ 60 = 34 remainder 50, so the week is 34:50. As a decimal, 2,090 ÷ 60 = 34.83 hours.
- Pay. At $32 an hour, 2,090 ÷ 60 × $32 = $1,114.67 before tax.
Why hours and minutes must be converted before multiplying
A timesheet total of 34:50 is not 34.5 hours and it is not 34.50 dollars’ worth of anything. The 50 is fifty sixtieths of an hour, which is 0.83. Multiplying a rate by “34.50” would underpay this week by more than $10.
Rounding early also costs money, though less. Wednesday’s 7:20 is 7.333… hours. Paid on the exact minutes it is worth $234.67 at $32 an hour. Rounded to 7.33 hours first, it comes to $234.56, which is 11 cents less. Across the week, 34.83 × $32 gives $1,114.56 against the exact $1,114.67. This calculator multiplies the rate by the exact minutes and rounds only the final dollar amount, which is why the weekly pay can differ by a cent from the sum of the daily figures shown.
Getting the timesheet right
- Only unpaid breaks come off. A paid rest break is part of your working time, so leave it out of the break box. An unpaid meal break goes in.
- Overnight shifts count on the day they start. The whole Thursday night shift above is recorded against Thursday. Payroll systems sometimes split a shift at midnight when different rates apply to each day, so the daily figures can differ from a payslip even when the weekly total agrees.
- Match your employer’s rounding. If start and finish times are rounded on your payslip, to the nearest quarter hour for example, enter the rounded times to reproduce the payslip figure.
- Full-time hours. A standard full-time week in Australia is 38 hours, which is 7 hours 36 minutes a day over five days, or 7.6 in decimal. The times this page opens with, 9:00 am to 5:00 pm with a 30-minute unpaid break, come to 7.5 hours a day and 37.5 hours a week.
- What is not included. Overtime, weekend and public holiday penalty rates, shift loadings, allowances and tax are left out. The pay figure is ordinary hours at one flat rate.