Features

Who it is for

More

Excel and PDF

Drive, job and emergency call per customer, with rest until the next morning

One row per drive and job, with the customer's signature. The Excel file sums up per customer and per type and flags when a night emergency call cuts the rest period.

Download XLSXDownload PDF
  • No sign-up
  • No newsletter
  • Free to use
Preview: Drive, job and emergency call per customer, with rest until the next morning

What is in the template?

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

  • Types drive, job, emergency and workshop as a drop-down list
  • A column for the customer's signature
  • Hours per customer and per type on a sheet of their own
  • Rest from the end of the emergency call until the first job in the morning
  • Jobs past midnight with the date of the start

When does the template fit?

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

  • Heating, air conditioning, refrigeration and lifts
  • Maintenance with emergency service in the evening and at weekends
  • A service report as a PDF at the customer
When Excel reaches its limits

Emergency call until one, drive out at seven: only someone with both rows side by side sees it.

With MetronHR the technician clocks in via the app at the customer, drive and job kept apart, at night too. The times per customer show up in the project straight away, and the rest can be read off before the next job.

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

Working time and client time in one list, with the billable shareGo to the templateProject, support and call-out times, with rest after a night call-outGo to the templateProject 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 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 the drive to the first customer working time?

For employees without a fixed or habitual place of work, yes: the drive from home to the first customer and from the last customer back home (CJEU, 10 September 2015, C-266/14). Pay can be governed separately by the contract.

Does a night emergency call interrupt the rest period?

According to the prevailing view, yes, the eleven hours start again after the call. With on-call duty, in principle only the call-out is working time; with a very short response time, all of the standby can be working time (CJEU, 9 March 2021, C-344/19 and C-580/19). Service and maintenance have no shortening to ten hours under section 5(2) ArbZG.

May service technicians work on Sundays?

For maintaining business equipment where the regular running of one's own or another business depends on it (section 10(1) no. 14 ArbZG). Every Sunday worked brings a replacement rest day within two weeks.

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