Free timesheet calculator for Australian workplaces
To total a timesheet, take each day's start time from its finish time, subtract any unpaid meal break, and convert the minutes to decimal hours by dividing by 60. Paid rest breaks stay in. Enter each day below and the calculator adds up the week and, if you enter a rate, estimates gross pay.
Total hours this week
—
Add a start and finish time to see the hours
Estimated gross pay
—
Ordinary hours × your rate (no penalties)
Average per worked day
—
Across days with hours entered
This tool totals ordinary hours only. It does not apply overtime, weekend or public-holiday penalty rates. For award pay, use the overtime & penalty rate calculator or a specific award guide.
How to calculate hours worked
Working out hours from a timesheet is a three-step job: find the gap between start and finish, subtract any unpaid breaks, then convert the result to decimal hours so it's easy to multiply by a pay rate. The calculator above does all three for you, but here's the manual method so you can check it.
Find the elapsed time
A shift from 9:00 to 17:30 is 8 hours 30 minutes. If a shift crosses midnight, add 24 hours to the finish time first.Subtract unpaid breaks
Take off any unpaid meal break — a 30-minute lunch turns 8h 30m into 8h 00m of paid time.Convert minutes to decimal
Divide the minutes by 60: 8h 15m becomes 8.25 hours. Multiply by the hourly rate for pay.Accurate timesheets matter for more than pay — Fair Work requires employers to keep time and pay records for seven years. Capturing real start and finish times (rather than rostered ones) with time and attendance software removes the manual maths and the disputes that come with it.
Decimal hours and the working year
Converting minutes to decimal hours
Payroll works in decimal hours, not hours-and-minutes. Divide the minutes by 60:
| Minutes | Decimal |
|---|---|
| 15 min | 0.25 |
| 30 min | 0.50 |
| 45 min | 0.75 |
| 10 min | 0.167 |
How many hours are in a work year?
A standard Australian full-time week is 38 hours. Over 52 weeks that's about 1,976 hours a year before leave. Take off four weeks of annual leave and public holidays and most full-time employees actually work closer to 1,800 hours.
There are 260 weekdays and roughly 251–253 working days in a typical year once public holidays are removed. To budget labour cost, multiply your weekly hours by your labour cost figures rather than guessing annual totals.
Hours and record rules checked against Fair Work on (38-hour full-time week under the National Employment Standards; seven years for time and pay records). The calculator totals ordinary hours only and applies no penalty or overtime rates. Sources
One part-time week, totalled
A café employee working five shifts. Each shift over five hours takes a 30-minute unpaid meal break; the paid 10-minute rest breaks are not entered.
| Day | Start | Finish | Unpaid break | Hours |
|---|---|---|---|---|
| Monday | 7:00 | 15:30 | 30 min | 8.00 |
| Tuesday | 7:00 | 15:30 | 30 min | 8.00 |
| Thursday | 10:00 | 14:15 | none | 4.25 |
| Friday | 14:00 | 22:45 | 30 min | 8.25 |
| Saturday | 8:00 | 13:30 | 30 min | 5.00 |
| Week | 33.50 |
Thursday’s 4 hours 15 minutes is 4.25 because 15 ÷ 60 = 0.25. Friday’s evening hours and Saturday’s hours usually attract penalty rates under an award, which this calculator does not add: cost them with the penalty rates and overtime calculator.
More time and pay tools
Sources: Fair Work Ombudsman, maximum weekly hours (National Employment Standards) and record-keeping (Fair Work Regulations 2009 reg 3.31 to 3.44).
Timesheet questions
-
Enter the unpaid break in minutes for each day and the calculator subtracts it from that day’s hours. A rostered 8-hour shift with a 30-minute unpaid lunch becomes 7.5 paid hours. Paid breaks, like a 10-minute rest break, are not entered: leave the field at 0.
-
Yes. If the finish time is earlier than the start time (for example 22:00 to 06:00), the calculator treats the shift as crossing midnight and counts 8 hours before any break is deducted.
-
No. It totals ordinary hours and, if you enter a rate, multiplies them for a gross pay estimate. For award pay, use the penalty rates and overtime calculator or the award rate guides.
-
Seven years. Fair Work requires employers to keep time and pay records that long, legible and in English, covering hours worked, pay, leave and super. Digital time and attendance records make this easier than paper timesheets.
-
No. The calculator runs in your browser and nothing is sent or stored. Refreshing or closing the page clears the entries, so copy or print the week to keep a record.
-
Work through five steps for each employee: take the approved timesheet, total the paid hours after unpaid breaks, split them into ordinary, overtime and penalty bands, multiply each band by its rate to get gross pay, then subtract PAYG withholding and any deductions to get net pay. Super is calculated on ordinary time earnings and paid on top, not taken out of the wage. This calculator does the first two steps; how to approve timesheets and how to reconcile payroll cover the checks either side of pay day.
-
Gross pay = (ordinary hours × base rate) + (overtime hours × overtime rate) + (penalty hours × penalty rate) + any allowances or loadings. For example, 38 ordinary hours at $30 is $1,140, plus 2 overtime hours at time and a half ($45) is $90, so gross pay is $1,230. Your award sets the overtime and penalty multipliers.
-
Net pay = gross pay − PAYG withholding − pre-tax deductions (such as salary sacrifice) − post-tax deductions (such as union fees). Work out PAYG from the ATO tax tables for the pay frequency, after any pre-tax deductions. The super guarantee is an employer cost on top of gross pay, not a deduction from it.
Timesheets filled from the time clock
Staff clock on and off; the hours land on the timesheet.
Approve the hours instead of adding them up
- Staff clock on and off on their phone or a kiosk
- Each timesheet shows the rostered and the clocked hours
- Corrections made before approval
- Approved hours exported to Xero, MYOB and more