Weekly timesheet template for New Zealand (Excel)
A weekly timesheet records one person’s week, Monday to Sunday: start and finish times, the unpaid meal break and paid hours each day, totalled for the week. This New Zealand template converts times to decimal hours for payroll, deducts only the meal break, and ends with employee and manager signatures.

Next week you’ll add these hours up by hand again.
In RosterElf staff clock in and out on their phone, you approve the hours against the roster, and approved timesheets go to Xero, MYOB or a Smartly file.
Your download has started.
What’s in the file
- One employee, Monday to Sunday: start, finish and unpaid break
- Paid hours per day and a week total by formula
- A code and notes column for leave and public holidays
- Employee and manager signature lines, and an Instructions tab
Clock time to decimal hours, and shifts past midnight
Payroll wants decimal hours. Typing minutes as decimals is one of the most common payroll errors.
| On the clock | Decimal hours | Not |
|---|---|---|
| 7 h 45 min | 7.75 | 7.45 |
| 8 h 15 min | 8.25 | 8.15 |
| 9 h 20 min | 9.33 | 9.20 |
| 6 h 50 min | 6.83 | 6.50 |
| 5 h 30 min | 5.50 | 5.30 |
The sheet works this out for you: =MOD(Finish-Start,1)*24 less the meal break ÷ 60, so a shift that finishes after midnight still totals correctly. Enter the times actually worked, not the rostered ones: the 15 minutes before opening on Thursday is working time, and unrecorded time is the usual route to an accidental minimum wage shortfall.
More NZ timesheet templates
Wage and time records and breaks: Employment Relations Act 2000; holiday and leave records: Holidays Act 2003. See employment.govt.nz. The template counts hours only; it does not work out pay.
Weekly timesheet questions
-
Subtract start from finish and multiply by 24 for decimal hours:
=(Finish-Start)*24. For a shift that crosses midnight use=MOD(Finish-Start,1)*24. Deduct the meal break as minutes ÷ 60. Format the time cells ash:mmand the result as a number. -
Enter times as
h:mm, because that is how people read a clock, and let the sheet convert to decimals. 7 hours 45 minutes is 7.75, not 7.45. -
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 the minimum wage has to be met for every hour worked.
-
No, only the meal break. Under the Employment Relations Act 2000 the 10-minute rest breaks are paid working time and stay in paid hours; the 30-minute meal break is unpaid and comes out. A shift of 2 to 4 hours has a paid rest break and no meal break to deduct.
-
At least six years, and you must be able to produce them for a labour inspector. If you cannot, section 132 of the Employment Relations Act 2000 lets the Employment Relations Authority accept the employee’s claims about their hours as proved.
Timesheets filled from the time clock
Staff clock on and off; the hours land on the timesheet.
Approve the hours instead of adding them up
- Staff clock on and off on their phone or a kiosk
- Each timesheet shows the rostered and the clocked hours
- Corrections made before approval
- Approved hours exported to Xero, MYOB and more