Free fortnightly timesheet template (Excel)
A two-week timesheet aligned with Australian fortnightly pay cycles. Built for businesses that pay every two weeks — download it, add your team, and track daily hours across both weeks with the fortnight total calculated for you.
Fortnightly timesheet
Excel format (.xlsx) • Ready to download
No signup required. Works with Excel and Google Sheets.
This fortnightly timesheet is a general planning and record-keeping tool only. It does not calculate wages, penalties, overtime or award entitlements. Verify pay with payroll software and check your obligations with Fair Work. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
What's in this template
A complete two-week timesheet layout
Employee name
Full name of each staff member, with manager and pay-period dates in the header rows.
Fortnight starting
Pay-period start and end dates so the 14 days line up with your Australian pay cycle.
Week 1 daily hours
Time in, time out and break columns for Monday through Sunday of the first week.
Week 2 daily hours
A matching set of daily columns for the second week, with its own weekly subtotal.
Fortnight total
A formula column sums both weeks so the period total is ready before payroll runs.
Notes column
Capture leave, exceptions or overtime context for any day across the two weeks.
How the fortnight is structured
Week 1 and Week 2 are tracked separately with their own subtotals, then combined into a single fortnight total. This mirrors a standard Australian fortnightly pay period, so the figure you hand to payroll matches the period exactly.
| Employee | Week | Mon | Tue | … | Week total | Fortnight |
|---|---|---|---|---|---|---|
| Sarah Jones | Week 1 | 8 | 8 | … | 40 | 76 |
| Week 2 | 8 | 6 | … | 36 |
How to create a fortnightly timesheet in Excel
Four steps to build one from scratch
1. Add the header
In rows 1–4 enter Employee Name, Manager and the Pay Period Start and End dates so every printout shows which fortnight it covers.
2. Build the 14-day table
From row 6, add column headers: Date, Day, Time In, Time Out, Break Duration, Regular Hours, Overtime Hours and Total Hours — then one row per day.
3. Calculate daily hours
Format the time cells as Time, then use =(Time Out − Time In)*24 to turn each day into decimal hours, subtracting the break.
4. Total the fortnight
Use =SUM() over both weeks to total the 14 days. Keep weekly subtotals so you can sanity-check Week 1 against Week 2 before payroll.
Prefer to skip the setup? The free template above already has the 14-day layout, time formulas and fortnight total built in. Once the hours are in, see our guide on calculating payroll from timesheets.
How to use this template
Download and go in four quick steps
Download
Grab the Excel file — no signup, opens in Excel or Google Sheets.
Add your team
Enter names and set the fortnight start and end dates.
Record both weeks
Fill in daily time in, time out and breaks for Week 1 and Week 2.
Export for payroll
The fortnight total totals automatically — send it to payroll processing.
Who uses this template
Ideal for businesses with fortnightly pay cycles
Cafes
Align timesheets with a fortnightly pay run
Retail stores
Track two weeks of floor-staff hours in one sheet
Hospitality
Match standard Australian fortnightly pay cycles
Once a spreadsheet can’t keep up, a digital way to track employee hours removes the manual totalling. Learn more about keeping legally defensible timesheets across each pay run.
When spreadsheets stop keeping up
A fortnightly timesheet in Excel works for a small team. But as you grow, chasing entries, fixing errors and manually totalling 14 days every pay run gets painful fast. RosterElf captures clock-ins automatically, tallies the fortnight for you, and exports payroll-ready hours straight from the kiosk or phone.
Time & attendance guides
Turn recorded hours into accurate pay
How to approve timesheets
A clear process for reviewing and signing off staff hours before each pay run.
Read the guideCalculate payroll from timesheets
Turn recorded hours into accurate pay, from ordinary hours through to overtime.
Read the guideTrack employee hours
Choose a reliable way to capture hours so your fortnightly totals always add up.
Read the guideRelated templates
Explore more free time and attendance templates
Fortnightly timesheet FAQ
-
Add a header for the employee, manager and pay-period start and end dates, then build a 14-day table with columns for date, day, time in, time out, break, regular hours and overtime. Format the time cells as Time and use =(Time Out − Time In)*24 to convert each day to decimal hours, then =SUM() to total the fortnight. Our free template comes pre-built with this layout, or follow the step-by-step section above. For turning those hours into pay, see our guide on calculating payroll from timesheets.
-
A fortnightly timesheet records hours across a 14-day pay period — the two-week cycle many Australian businesses use to pay staff. It keeps both weeks on one sheet so the period total matches exactly what you run through payroll.
-
No — it tracks hours only. It does not calculate wages, penalties, overtime loadings or award entitlements. For automated, pay-aware totals connect your hours to payroll integration rather than relying on a spreadsheet.
-
Yes — upload the .xlsx file to Google Sheets (New → File upload in Google Drive) and the layout and formulas carry across. You can edit and share it from there with no signup required.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, awards and workplace requirements.