medishift

Timesheet Template with Overtime: Excel & PDF

Free timesheet template for Excel and as a printable PDF: four weeks for one person, with weekly overtime, pay at your overtime rate and break and rest checks.

Updated November 2026 · Excel and PDF · no sign-up

Without Excel: do it in medishift instead, start for free →

timesheet-template.xlsx
Timesheet Template with Overtime: Excel & PDF

What's in the template

Each sheet has one job. This is how they work together.

timesheet-template.xlsx · Timesheet
  1. Ansicht des Blatts „Timesheet“

This timesheet template records four weeks of hours for one person in Excel. You enter start, end and break; the file works out hours per week, overtime above the contracted hours and pay at your overtime rate. To fill in by hand there is the same timesheet as a blank PDF.

How to fill in the template

  1. Enter the name, week commencing date, contracted hours, hourly rate and overtime rate.
  2. For each day, enter start, end and break in minutes.
  3. Check the totals, overtime and pay, and any red finding in the ‘Check’ column.
  4. Print, sign and hand in, or use the blank PDF to fill in by hand.

How the template calculates

Hours = end − start − break (if the end is before the start, it is the next day)Overtime per week = hours above the contracted weekly hoursPay = (hours − overtime) × hourly rate + overtime × hourly rate × overtime rate
20-minute break when working time is more than 6 hoursWTR 1998 reg 12
At least 11 hours of rest between two shiftsWTR 1998 reg 10
Records that show the 48-hour average is kept to, held for two yearsWTR 1998 reg 9; NI: WTR (NI) 2016 reg 11

Time tracking for small teams, explained →

Limits of the template

For a small team the file is enough. This is where it reaches its limits.

  • Northern Ireland has its own Working Time Regulations (2016) with the same rules under different regulation numbers.
  • One file is one person for four weeks.
  • Overtime is counted per week above the contracted hours; paid breaks, unsocial hours rates and TOIL rules are not built in.
  • Bank holidays are not marked; leave the day empty or note it.
  • Collecting and signing happen on paper or by email.

Excel timesheet or medishift

The template is enough when a handful of people hand in their hours once a month. When you want to check hours as they come in, medishift records them in the app.

CriterionExcel templatemedishift
Recording hourspartly: typed in at the end of the weekyes: clock in and out in the app or on a tablet with a PIN
Checkingpartly: chase sheets, then add upyes: entries arrive as they happen, you approve them
Rest and long weekspartly: red finding in the ‘Check’ columnyes: entries under 11 hours of rest or over 48 hours a week are flagged
Overtimepartly: per sheet and per weekyes: an overtime balance for each person
Signing offpartly: print and signyes: approve in the app

Time tracking is not part of the free plan of medishift. You can try every feature for the first 14 days.

Clock in instead of filling in

In medishift staff clock in and out in the app or on a tablet with a PIN. Breaks are recorded too, and entries with less than 11 hours of rest are flagged. Time tracking is not part of the free plan; you can try every feature for the first 14 days.

    More about clocking in and out
    Time tracking in the medishift app

    See medishift in 30 minutes

    We show you, using your own team, how rota, time tracking and leave work together without Excel. Pick a time that suits you.

    • 30 minutes
    • Via Google Meet
    • Free and without obligation

    1. Pick a slot

    November 2026
    MonTueWedThuFriSatSun

    Wednesday 18 November

    Loading available slots …

    FAQ: Timesheet template

    Yes. You download it as an Excel file or a blank PDF, without signing up.

    For every week it takes the hours worked above the contracted weekly hours. A short week does not cancel out a long one, because overtime is counted week by week.

    Yes. Enter the hourly rate and the overtime rate, for example 1.5 for time and a half. The file shows basic pay, overtime pay and the total for the four weeks.

    Yes. More than six hours of work with under 20 minutes of break turns the day red (regulation 12 of the Working Time Regulations 1998), and so does a start less than 11 hours after the last shift ended (regulation 10).

    Yes. The blank PDF has the same layout to fill in by hand, with signature lines for the employee and the manager.

    Yes. The file uses only functions that Excel and Google Sheets both know, so the totals and checks work after you upload it to Google Drive.