Quillroo

Timesheet calculator with breaks and overtime

Enter start and finish times and unpaid breaks for each day to get hours worked in hours and minutes and as decimal hours, with overtime after a daily limit, a weekly limit (38 hours by default), or both. Add an hourly rate to see gross pay with overtime multipliers. Overnight shifts work too. Print the timesheet or download it as a CSV.

Everything runs in your browser. Your times are kept in this browser so they're still there next time; nothing is sent anywhere.

CalculatorHow it worksExamplesFAQ

DayStartFinishUnpaid break (min)Hours
Overtime and pay (optional)

How it works

Examples

TimesheetTotalOvertime
9:00 to 17:30 with a 30-minute break8:00 (8.00)0:00
Night shift 22:00 to 06:00 with a 30-minute break7:30 (7.50)0:00
Five days of 8:00 to 17:00 with 30 minutes' break (8.5 h a day), overtime after 38 h a week42:30 (42.50)4:30
Four 10-hour days, overtime after 8 h a day and 38 h a week40:008:00 (daily)
42.5 hours at $30, overtime after 38 h: first 2 overtime hours ×1.5, then ×2$1,380.00$240.00
Keeping records

Fair Work says employers should keep records of hours worked for all employees, and must in some situations, such as for casual or irregular part-time employees. Where overtime penalty rates or loadings are paid, the record must show the overtime hours worked each day or when the overtime started and finished. A printed or saved timesheet from this page shows start and finish times for each day.

FAQ

How do I calculate hours worked with a lunch break?

Subtract the start time from the finish time, then subtract the unpaid break. 8:30am to 5:00pm is 8 hours 30 minutes; take off a 30-minute lunch and you worked 8 hours. Enter the break minutes for each day and the calculator does this for every row.

How do I convert hours and minutes to decimal hours?

Divide the minutes by 60 and add them to the hours. 7 hours 45 minutes is 7 + 45 ÷ 60 = 7.75 hours; 15 minutes is 0.25 and 20 minutes is 0.33. The calculator shows both formats.

How is overtime worked out?

Hours over your daily limit are overtime first. The remaining ordinary hours in each week are then compared with the weekly limit (38 by default) and the excess is overtime too. Five 8.5-hour days make 42.5 hours, which is 4.5 hours over 38.

What overtime rate should I use?

That depends on the award, enterprise agreement or contract, which is why this calculator doesn’t assume one. Many awards pay time and a half for the first 2 or 3 hours and double time after that, which you can set with the two multipliers. Check the Fair Work pay guide for your award.

Does it handle night shifts?

Yes. If the finish time is earlier than the start time, the shift is treated as finishing the next day, so 22:00 to 06:00 counts as 8 hours before breaks. The day is the one the shift started on.

Is my timesheet saved?

Your entries are kept in this browser’s local storage so they’re still there when you come back on the same device. Nothing is sent to a server. Use Clear to remove them, or Download CSV to keep a copy.

Sources (checked 17 Oct 2026): Fair Work Ombudsman Maximum weekly hours fact sheet (38 hours plus reasonable additional hours); Fair Work Ombudsman Record-keeping (hours and overtime records); Fair Work Ombudsman Breaks; ATO What payments are qualifying earnings (overtime isn't counted for super guarantee).

General information, not tax advice or workplace advice. This calculator doesn't know your award or agreement. It doesn't apply award pay rates, penalty rates, minimum shift lengths or break rules: you set the overtime thresholds and multipliers. Check the Fair Work pay guides for what applies to you.

Related free tools