Features

Who it is for

More

Excel and PDF

Project, support and call-out times, with rest after a night call-out

One row per task with client, ticket and type. The Excel file sums up per client and type and flags when the rest until work starts is missing after a night call-out.

Download XLSXDownload PDF
  • No sign-up
  • No newsletter
  • Free to use
Preview: Project, support and call-out times, with rest after a night call-out

What is in the template?

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

  • Types project, support, on-call call-out, Sunday maintenance, internal
  • Hours per client and per type on sheets of their own
  • Rest from the end of the call-out to the next start of work, on the same day too
  • A daily check: ten hours and breaks under section 4 ArbZG
  • Notes on on-call duty, CJEU case law and Sunday maintenance

When does the template fit?

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

  • IT service providers with standby for clients
  • System houses and managed services
  • Maintenance windows at weekends
When Excel reaches its limits

Twenty minutes of call-out at three in the morning move the whole next day.

In MetronHR everyone books their time in the browser or the app to client and project, at night too. In the Professional plan the hours per client show up in the project budget straight away, and at month end the payroll file goes to the accountant.

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

Project time and travel time kept apart, with what counts under the ArbZGGo to the templateTimes per hirer under section 17c AUeG, with the 7-day deadlineGo to the templateVolunteers, coaches and mini-jobs: assignments, allowances and the earnings limitGo to the templateA timesheet and working time record as an Excel template or a printable PDFGo 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
Is on-call duty working time?

In principle only the call-out. If requirements such as a very short response time very significantly restrict free time, all of the standby can be working time (CJEU, 9 March 2021, C-344/19 and C-580/19).

When may work resume after a call-out at 3 am?

According to the prevailing view, the rest period starts again after the call-out. Anyone who worked until 3:20 am starts at 2:20 pm at the earliest without a different collective agreement (section 7(2) no. 1 ArbZG). The template flags exactly this case in the example.

May IT teams do maintenance on Sundays?

Yes, to keep data networks and computer systems working (section 10(1) no. 14 ArbZG). Every Sunday worked brings a replacement rest day within two weeks (section 11 ArbZG).

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