Free weekly timesheet template (Excel)
One person, one week, Monday to Sunday. Enter start and finish times and the unpaid meal break, and the sheet works out paid hours per day and for the week.
Weekly timesheet
Excel format (.xlsx) • Ready to download
No signup required. Works with Excel, Google Sheets and LibreOffice.
This template is a record-keeping tool, not legal or payroll advice. It does not calculate annual holiday pay, public holiday pay or an alternative holiday balance for you, and it does not check that minimum wage has been met. Check Employment New Zealand, or take advice, before relying on a spreadsheet for compliance. 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.
Roster and track hours in one place
A timesheet only records what already happened. Roster the shifts first and the hours record themselves — free, no signup.
What's in this template
A week of hours that adds itself up
Monday to Sunday
Seven day rows in the order New Zealand weeks are counted, matching how rosters and pay periods are usually set.
Start and finish times
Enter times as 9:00 and 17:30. The sheet converts to decimal hours, which is what payroll wants.
A meal break column, not a break column
Pre-filled at 30 minutes and deducted. The 10-minute paid rest breaks are working time and deliberately stay in.
Paid hours per day
Finish minus start minus the unpaid meal break, calculated per row and totalled for the week.
Sign-off lines
Employee confirms, manager signs. An unapproved timesheet is much weaker evidence if the hours are ever disputed.
Built for the record you must keep
Hours worked each day is exactly what the Employment Relations Act 2000 wage and time record calls for.
How a week is recorded
Enter the times actually worked, not the times on the roster. The meal break is deducted, so a 9:00–17:30 day with a 30-minute unpaid meal break is 8.0 paid hours, not 8.5.
| Day | Start | Finish | Unpaid break | Paid hours | Notes |
|---|---|---|---|---|---|
| Monday | 9:00 | 17:30 | 30 min | 8.0 | |
| Tuesday | 9:00 | 19:15 | 30 min | 9.75 | Stayed to close — delivery ran late |
| Wednesday | — | — | — | 0.0 | Annual holiday (AL) |
| Thursday | 8:45 | 17:30 | 30 min | 8.25 | Opened early |
The 15 minutes before opening on Thursday is working time and it is on the sheet. Unrecorded time like that is the most common route to an accidental minimum wage shortfall — it is real work, it is rarely written down, and it is invisible in a timesheet copied from the roster.
How to fill in the weekly timesheet
Four steps, once a week
1. Set the header
Employee name and the Monday the week starts on. One sheet per person per week.
2. Enter actual times
Start and finish as they happened, to the nearest five minutes. Rounding only in the employer's favour is how shortfalls accumulate.
3. Record the unpaid meal break
Only if it was genuinely uninterrupted. If they stayed on the floor or answered the phone it was not a break, and it is paid.
4. Approve it weekly
Employee confirms, manager signs. Approve weekly, not monthly — nobody accurately remembers a Tuesday three weeks ago.
The formulas are already in place. Type into the white cells only; the shaded ones calculate.
Who uses this template
New Zealand teams on a weekly pay cycle
Hospitality
Where the finish time on the roster is almost never the finish time worked.
Trades and contractors
Weekly hours per person per site, with travel between sites recorded as working time.
Retail
Opening and closing time that sits outside the rostered shift and still has to be paid.
Paid fortnightly? The fortnightly timesheet keeps both weeks on one sheet with separate weekly subtotals.
Or stop collecting timesheets altogether
A timesheet is filled in after the fact. RosterElf timestamps the clock-in and clock-out as they happen, deducts the meal break, and sends approved hours straight to Xero or Smartly — no chasing, no reconstruction.
The rest of the set
Other ways to record the same hours
Employee attendance register
A month grid of who was in, who was away and why, with present, absent and leave counted per person.
Download the templateFortnightly timesheet
Two weeks on one sheet with separate weekly subtotals — for a fortnightly pay cycle.
Download the templateDaily time clock sheet
One day, the whole team, initialled at the end of the shift.
Download the templateMore free New Zealand tools
Plan the shifts, then cost them
Free staff roster templates
Weekly, fortnightly, monthly, daily and blank rosters in Excel — the planning side of the same job.
Browse the rostersHolidays Act leave calculator
Annual holidays at the greater of ordinary weekly pay and average weekly earnings.
Open the calculatorAll free NZ tools
Calculators and builders for rostering, labour cost and payroll readiness.
See all toolsWeekly timesheet FAQ
-
Subtract start from finish and multiply by 24 to get decimal hours:
=(C2-B2)*24. Deduct the meal break the same way. Format the time cells ashh:mmand the result as a number, or Excel shows you a time instead of a quantity. For a shift crossing midnight use=(C2-B2+(C2<B2))*24. The template has all of this built in. -
Enter times as
hh:mmbecause that is how people read a clock, and let the sheet convert to decimals for the total. Payroll almost always wants decimal hours — 7 hours 45 minutes is 7.75, not 7.45, and typing 7.45 is one of the most common payroll errors there is. -
If you round at all, round to the nearest five or ten minutes in both directions. Rounding down consistently means some hours are worked and not paid, and minimum wage has to be met for every hour actually worked.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — the time arithmetic and the weekly total carry over. It works in LibreOffice Calc too.
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, employment agreements and workplace requirements.