Fortnightly (bi-weekly) timesheet template

Both weeks of a fortnight on a single sheet. Hours for each day, each week and the whole fortnight are worked out, with hours over a limit you set split out.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

More about each format: Excel, PDF, Word

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

Worked example: fortnight starting Monday 1 March 2027, limit of 72 hours
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

  1. Type the employee, the approver and the first day of the fortnight.
  2. If you split hours over a limit, type the hours in a fortnight before overtime. You choose the number; leave it blank for none.
  3. 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.
  4. Read week 1, week 2 and the fortnight under the table.
  5. 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+E25

Week 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.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.