What it's for
- Staff paid every two weeks, in Australia, the UK, the US and elsewhere.
- Managers who approve hours once a fortnight.
- A fortnight that starts on any day: you type the first day.
What's inside
- How to use
- Short instructions and the colour key.
- Timesheet
- The first day, 14 dated rows with start, finish and unpaid break, week 1, week 2 and fortnight totals, days worked, hours over your limit, and signature lines.
Preview
| Week | Days | Hours | Detail |
|---|---|---|---|
| Week 1 | Mon to Fri | 40.00 | 9:00 to 17:30 with a 30 minute break each day |
| Week 2 | Mon to Fri | 36.50 | Mon, Wed and Thu 8.00; Tue 9:00 to 18:00 is 8.50; Fri 9:00 to 13:00 is 4.00 |
| Fortnight | 10 days | 76.50 | 72.00 up to the limit, 4.50 over |
The fortnight totals 76.50 hours over 10 days worked. With the limit set to 72 hours, 72.00 are up to the limit and 4.50 are over it. Leave the limit blank to split nothing out.
How to use it
- Type the employee, the approver and the first day of the fortnight.
- If you split hours over a limit, type the hours in a fortnight before overtime. You choose the number; leave it blank for none.
- Each day, type the start and finish time (like 9:00 and 17:30) and any unpaid break in minutes. Leave days you did not work blank.
- Read week 1, week 2 and the fortnight under the table.
- Print the sheet, sign it and pass it on.
The formulas, explained
- Hours worked
-
=IF(OR(B9="",C9=""),0,MAX(0,MOD(C9-B9,1)*24-N(D9)/60))MOD(finish − start, 1) is the time between the two, even after midnight, times 24 for hours, less the break in minutes ÷ 60.
- Fortnight hours
-
=E24+E25Week 1 (the sum of rows 9 to 15) plus week 2 (rows 16 to 22).
- Hours over the limit
-
=IF(N(B6)<=0,0,MAX(0,E26-B6))Hours in the fortnight past the limit you typed. Blank, 0 or text means no limit.
- Days worked
-
=COUNTIF(E9:E22,">0")Counts the days with more than 0 hours.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
Is bi-weekly the same as fortnightly?
In payroll, yes: both mean every two weeks, which is usually 26 pay periods a year. "Bi-weekly" is the common word in the US and "fortnightly" in Australia and the UK. Semi-monthly is different: it means twice a month.
How is this different from the weekly template?
The weekly and fortnightly template splits each week across two sheets and has overtime presets. This is one sheet with a single limit for the whole fortnight, built to print on one page.
What limit should I type?
The file does not suggest one. It depends on the contract, award or agreement that applies to the employee, and it can differ by country. Leave it blank if you only need the hours.
Can the fortnight start on a Wednesday?
Yes. Type any first day and the 14 dates follow from it.
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, ISNUMBER, SUM and COUNTIF). 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.