Fortnightly timesheet template for Excel

An .xlsx timesheet for two weeks on one sheet. Type start and finish times and breaks, and the hours for each week and the fortnight are worked out.

  • No email needed
  • .xlsx file
  • Last reviewed 15 November 2026
Download Excel (.xlsx), Fortnightly timesheet, 10 KB

Other formats: PDF, Word · All about this template

What's in the Excel file

  • 14 dated rows that fill in from the first day you type, with start, finish, unpaid break and hours.
  • Week 1, week 2 and fortnight totals, days worked, and hours over and up to a limit you choose.
  • Signature lines for the employee and the approver.

How to use it in Excel

  1. Download the file. Use the download button on this page to save fortnightly-timesheet.xlsx.
  2. Open it in Excel. Open the file. If Excel opens it in Protected View, choose Enable Editing so the formulas can calculate.
  3. Set the fortnight. Type the employee, the approver and the first day. Type a limit in hours if you want hours over it split out.
  4. Enter each day. Type the start and finish time and any unpaid break in minutes. Leave days off blank.
  5. Print and sign. Read the totals under the table, print the sheet and sign it for the approver.

The formulas inside

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.

What the Excel version doesn't do

  • There is one limit for the whole fortnight. It has no daily limit or presets: use the weekly and fortnightly template for those.
  • It does not work out pay, tax or any award rates.

Questions

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive, or use File > Import in Google Sheets. It only uses functions both programs have. We do not offer a "make a copy" link, because that needs a Google account to host it.

Is this a bi-weekly timesheet?

Yes. Bi-weekly here means every two weeks, which is the same as fortnightly.

Last reviewed 15 November 2026. 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.