medishift

Hospital Rota Template: Free 24/7 Ward Rota

Free hospital rota template for Excel: long days, nights and twilights for up to 25 staff over four weeks, with rest and break checks and UK bank holidays.

Updated November 2026 · Excel · no sign-up

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

hospital-rota-template.xlsx
Hospital Rota Template: Free 24/7 Ward Rota

What's in the template

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

hospital-rota-template.xlsx · Rota
  1. Ansicht des Blatts „Rota“

This hospital rota template plans a 24/7 ward in Excel: long days, nights, twilights, earlies and lates for up to 25 staff over four weeks. It checks the 11 hours of rest after every shift, including the step from a twilight to an early, and marks the bank holidays of your nation.

How to fill in the template

  1. On the ‘Rota’ sheet, enter the start date and your nation.
  2. On the ‘Shifts’ sheet, set start, end and break for your ward.
  3. Enter names in column B and pick a code for each day.
  4. Look at the red findings on the ‘Checks’ sheet and adjust the rota.
  5. Print the rota or save it as a PDF for the ward.

How the template calculates

Working hours = end − start − break (a night ending at 08:00 ends the next morning)Rest = start today + 24 hours − end yesterday, only when both days are shiftsDays off = 7 − days with a shift, for each week from Monday
At least 11 hours of rest between two shiftsWTR 1998 reg 10
20-minute break when working time is more than 6 hoursWTR 1998 reg 12
Weeks over 48 hours marked, because 48 is the average over 17 weeksWTR 1998 reg 4
Weeks without a day off marked, for the weekly rest of 24 hoursWTR 1998 reg 11

Which rota shape fits a ward, and the rest rules that catch people out →

Limits of the template

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

  • The findings sit on their own sheet, not in the cells of the rota itself.
  • Skill mix per shift, such as one registered nurse on every night, is not counted.
  • The 48-hour average over 17 weeks needs more than four weeks; the file only marks single weeks above 48.
  • A day off after a night counts as off, even though the night ends that morning; weekly rest across that day is not measured.
  • Northern Ireland has its own Working Time Regulations (2016) with the same limits under different regulation numbers.
  • Night work limits, the terms for doctors in training and collective agreements are not checked.
  • One person plans in one file. Swaps and changes are not recorded.

Excel hospital rota or medishift

The template is enough to build a ward rota by hand. If it should be ready faster, follow your own rules automatically or cover sickness fairly, medishift does that with the AI assistant Kira.

CriterionExcel templatemedishift
Rota to the wardpartly: print it or email ityes: publish it, everyone sees it in the app
Annual leavepartly: request on paper, then type ALyes: request in the app, on the rota once approved
Building the rotapartly: cell by cell by handyes: Kira fills the week by your rules, you accept the suggestion
Sickness at short noticepartly: ring round, then change the fileyes: open shift, or Kira suggests who can cover, fairly
Rota on the gopartly: printout in the staff roomyes: app for iOS and Android

Automatic weekly planning and cover suggestions with Kira are not part of the free plan of medishift. You can try every feature for the first 14 days.

The ward rota on every phone

In medishift you publish the rota and everyone sees their shifts in the app. Leave requests come in there too, and an open shift reaches the whole team at once.

    More about rota planning
    A ward rota 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: Hospital rota template

    Early 07:30 to 15:30, late 13:00 to 21:00, long day 07:30 to 20:00, night 19:30 to 08:00, twilight 15:00 to 23:00 and study, plus annual leave, sick leave and off. You change the times on the ‘Shifts’ sheet and have ten free rows for your own.

    Yes. If there are fewer than 11 hours between the end of one shift and the start of the next, the ‘Checks’ sheet shows a red finding with the actual rest. A twilight to 23:00 followed by an early at 07:30 shows ‘Rest 8.5 h’.

    A shift whose end is before its start ends the next day. A night from 19:30 to 08:00 with a 60-minute break counts as 11.5 hours, and the rest before the next shift is measured from 08:00.

    Because the 48-hour limit is an average over 17 weeks under regulation 4 of the Working Time Regulations, not a cap for one week, and a worker can opt out of it in writing. A week of long days can pass 48 hours without breaking the rule.

    Yes. The file holds the bank holidays from gov.uk for England and Wales, Scotland and Northern Ireland from 2026 to 2028, including substitute days. You pick your nation on the ‘Rota’ sheet.

    Twenty-five people over four weeks. For a larger ward, keep one file per team or per band.

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