Duty roster for reception, night audit and housekeeping
A weekly plan with night duties past midnight. The Excel file recognises the next day, adds up the hours and flags rest that is too short when switching from late to early.
- No sign-up
- No newsletter
- Free to use
What is in the template?
Ready to use, with formulas, sample data and a legend.
- Night audit into the morning, without converting times
- Rest at every change, flagged below the minimum you set
- Break check under section 4 ArbZG and days over ten hours
- A weekly total with a note over 48 and over 60 hours
- Example shifts for reception early and late, night audit, housekeeping
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Hotels and guesthouses with a 24-hour reception
- Housekeeping with changing teams
- A notice at the staff entrance as a PDF
Someone back at reception early after a late duty does not stand out in the plan.
MetronHR checks rest and maximum hours while you assign the shift, in the Professional plan. Shifts past midnight land on the right day, and people clock in at the terminal or in the app.
| Excel template | MetronHR | |
|---|---|---|
| Upkeep | Manual upkeep | Automatic calculations |
| Approvals | No workflows | Approval workflow |
| Reminders | No reminders | Reminders |
| Team | Copy again for every employee | One central source for the whole team |
Also goes with this
Frequently asked questions
Answers on usage and legal aspects.
Question not answered here? Every step is explained in the help centre.
Send us a messageHow much rest is needed between a late and an early duty in a hotel?
In principle eleven hours (section 5(1) ArbZG). In accommodation businesses it may drop to ten hours if every shortening is compensated within a calendar month or four weeks by at least twelve hours of rest (section 5(2) ArbZG). Late until 11 pm and early from 6:30 am leaves only seven and a half hours.
Is the night audit night work?
Yes, if more than two hours fall into the night time from 11 pm to 6 am (section 2(3) and (4) ArbZG). Anyone working like this regularly is entitled to occupational health checks and to a premium or days off (section 6 ArbZG).
Does a special recording duty apply in hotels?
Yes. The accommodation trade is listed in section 2a SchwarzArbG. The start, end and duration of daily working time of all employees have to be recorded by the end of the seventh calendar day and kept for two years (section 17 MiLoG).
Templates are a start. MetronHR is the answer.
When Excel reaches its limits in a team, MetronHR takes over the process. Try it free for 14 days.
- No credit card required
- Ready quickly
- Cancel monthly
- Full access to every feature
Ready in 5 minutes, no credit card