Excel and PDF

Duty roster for site and event security, with night duty

A weekly plan for day, late, night and event duties. The Excel file calculates past midnight and flags shifts over ten hours and rest that is too short.

  • No sign-up
  • No newsletter
  • Free to use
Preview: Duty roster for site and event security, with night duty

What is in the template?

Ready to use, with formulas, sample data and a legend.

  • Day, late, night and event duty as examples
  • Duties past midnight without converting times
  • A flag over ten hours, even where a collective agreement allows more
  • Rest after every duty, breaks under section 4 ArbZG
  • A weekly total with a note over 48 and over 60 hours

When does the template fit?

Ideal as an interim solution or for small teams, with clear limits.

  • Site security with day and night cover
  • Events late into the night
  • A notice at the guard post as a PDF
When Excel reaches its limits

Late duty until 10 pm, day duty from 6 am: someone has to see that beforehand.

MetronHR checks rest and maximum hours while you assign duties, in the Professional plan, and matches assignments against the person's stored certificates. People clock in via the app on site or at a terminal.

In comparison
Excel templateMetronHR
UpkeepManual upkeepAutomatic calculations
ApprovalsNo workflowsApproval workflow
RemindersNo remindersReminders
TeamCopy again for every employeeOne central source for the whole team

Frequently asked questions

Answers on usage and legal aspects.

Question not answered here? Every step is explained in the help centre.

Send us a message
Are twelve-hour shifts allowed in security services?

Only with a rule under section 7 ArbZG, for example a collective agreement providing for a considerable amount of standby time. Without one, the limit of ten hours a day applies (section 3 ArbZG). The template therefore always flags longer shifts.

What applies to night duties?

Night work is work with more than two hours between 11 pm and 6 am. For night workers the average of eight hours has to be reached within a calendar month or four weeks, plus health checks and a premium or days off (section 6 ArbZG).

Does working time have to be recorded in the security trade?

Yes. The security 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