What it's for
- Employers who split overtime on a daily or weekly limit, whatever that limit is for their award, agreement or contract.
- Checking a month of hours for one employee, week by week.
- Staff who want to see regular and overtime hours side by side.
What's inside
- How to use
- Short instructions and the colour key.
- Timesheet
- Employee, approver, first day, your daily limit, weekly limit and overtime multiplier, then 28 dated rows with start, finish, unpaid break, hours, daily overtime and regular hours.
- Summary
- For each of the four weeks and in total: hours worked, daily overtime, weekly overtime, regular hours and counted hours, with signature lines.
Preview
| Day | Start | Finish | Break | Hours | Daily overtime | Regular |
|---|---|---|---|---|---|---|
| Mon | 09:00 | 17:30 | 30 min | 8.00 | 0.00 | 8.00 |
| Tue | 08:30 | 19:00 | 30 min | 10.00 | 2.00 | 8.00 |
| Wed | 09:00 | 17:30 | 30 min | 8.00 | 0.00 | 8.00 |
| Thu | 09:00 | 17:30 | 30 min | 8.00 | 0.00 | 8.00 |
| Fri | 09:00 | 17:30 | 30 min | 8.00 | 0.00 | 8.00 |
The week is 42.00 hours. Daily overtime is 2.00 (Tuesday). That leaves 40.00 regular hours, and 2.00 of them are past the weekly limit of 38, so weekly overtime is 2.00. Overtime totals 4.00 and regular hours are 38.00, which add back to the 42.00 worked. Counted hours are 38.00 + 4.00 × 1.5 = 44.00. The limits and multiplier are examples you replace.
How to use it
- Type the employee, the approver and the first day of week 1.
- Type your daily overtime limit (hours in a day) and your weekly limit (regular hours in a week). Leave either blank for none.
- Type the multiplier overtime counts at, such as 1.5, or 1 (or leave it blank) to count it as regular time.
- Each day, type the start and finish time and any unpaid break in minutes.
- Read the Summary, then print it, sign it and pass it on.
The formulas, explained
- Hours worked
-
=IF(OR(B11="",C11=""),0,MAX(0,MOD(C11-B11,1)*24-N(D11)/60))Finish minus start, even after midnight, times 24, less the break in minutes ÷ 60.
- Daily overtime
-
=IF(N($B$6)<=0,0,MAX(0,E11-$B$6))Hours in the day past the daily limit you typed. Blank, 0 or text means no daily limit.
- Weekly overtime
-
=IF(N(Timesheet!$B$7)<=0,0,MAX(0,D5-Timesheet!$B$7))Regular hours in the week (after daily overtime) past the weekly limit, so one hour is never counted twice.
- Counted hours
-
=G5+F5*IF(N(Timesheet!$B$8)<=0,1,Timesheet!$B$8)Regular hours plus overtime hours times your multiplier. A blank multiplier counts overtime as regular time (1). These are hours, not pay.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
What daily and weekly limits should I use?
The file does not suggest any. Limits depend on the employee's award, agreement or contract and the rules where you operate, and they change. Type the numbers that apply to you, and check them with your regulator or an adviser.
Does it work out overtime pay?
No. It splits hours and counts them at the multiplier you type. It does not know the pay rate, tax or any award or agreement loading.
What if I use no daily limit?
Leave the daily limit blank. Daily overtime is then 0.00 and only the weekly limit applies.
How is this different from the weekly and fortnightly template?
That file has one-click presets and two weeks. This one has four weeks, your own two limits, a multiplier and a summary for each week, and no presets.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MAX, MOD, N and SUM). It also opens in LibreOffice.
About this template
Last reviewed 15 November 2026.
Changes: 15 November 2026: first published.
Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.