Features

Who it is for

More

Excel and PDF

Shift roster for service hours with early, mid and late shifts

A weekly plan for a hotline from morning to evening. The Excel file adds up the hours and flags rest that is too short when switching from late to early and missing breaks.

Download XLSXDownload PDF
  • No sign-up
  • No newsletter
  • Free to use
Preview: Shift roster for service hours with early, mid and late shifts

What is in the template?

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

  • Early, mid and late shift as examples
  • Rest when changing between shifts
  • A break check under section 4 ArbZG per day
  • A weekly total per person with a note over 48 hours
  • Notes on screen breaks and Sunday duty

When does the template fit?

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

  • Customer service and hotlines with long service hours
  • Teams with part-time staff and changing shifts
  • A notice as a PDF in the team area
When Excel reaches its limits

When a break is missing, the system should speak up, not the supervisor.

MetronHR checks breaks under section 4 ArbZG, rest and maximum hours, while you plan in the Professional plan. People clock in in the browser at their desk or in the app, also when working from home.

How MetronHR solves it
In comparison
Excel templateMetronHR
UpkeepManual upkeepAutomatic calculations
ApprovalsNo workflowsApproval workflow
RemindersNo remindersReminders
TeamCopy again for every employeeOne central source for the whole team
More templates

Also goes with this

Timesheet per site, with the 7-day deadline under section 17 MiLoGGo to the templateHours per job for payroll and job costingGo to the templateAttendance and job time kept apart, with labour units and efficiencyGo to the templateDrive, job and emergency call per customer, with rest until the next morningGo to the template

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 screen breaks the same as rest breaks?

No. Screen work has to be interrupted regularly with other tasks or recovery time (annex no. 6.1 ArbStättV). These interruptions do not replace the rest breaks under section 4 ArbZG if work is done during them.

May a call centre work on Sundays?

Call centres are not among the exceptions in section 10 ArbZG. The Federal Administrative Court declared a Hessian state ordinance invalid on 26 November 2014 insofar as it permitted them (6 CN 1.13). Sunday duty needs an exception for the specific work or a permit from the supervisory authority (section 13 ArbZG).

Late shift until 10 pm, early shift from 7 am: is that allowed?

No, that is nine hours of rest instead of the eleven in section 5(1) ArbZG. Call centres have no statutory shortening. The template flags exactly this change in the example.

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.

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