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 →

What's in the template
Each sheet has one job. This is how they work together.
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
- On the ‘Rota’ sheet, enter the start date and your nation.
- On the ‘Shifts’ sheet, set start, end and break for your ward.
- Enter names in column B and pick a code for each day.
- Look at the red findings on the ‘Checks’ sheet and adjust the rota.
- 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 shifts | WTR 1998 reg 10 |
| 20-minute break when working time is more than 6 hours | WTR 1998 reg 12 |
| Weeks over 48 hours marked, because 48 is the average over 17 weeks | WTR 1998 reg 4 |
| Weeks without a day off marked, for the weekly rest of 24 hours | WTR 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.
| Criterion | Excel template | medishift |
|---|---|---|
| Rota to the ward | partly: print it or email it | yes: publish it, everyone sees it in the app |
| Annual leave | partly: request on paper, then type AL | yes: request in the app, on the rota once approved |
| Building the rota | partly: cell by cell by hand | yes: Kira fills the week by your rules, you accept the suggestion |
| Sickness at short notice | partly: ring round, then change the file | yes: open shift, or Kira suggests who can cover, fairly |
| Rota on the go | partly: printout in the staff room | yes: 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.

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
Wednesday 18 November
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.
Related templates

Weekly Work Schedule Template: Free Excel & PDF
Free weekly work schedule template for Excel and as a printable PDF: start and finish times, hours against the contract, rest checks and a monthly plan.

Rota Template Excel: Free 4-Week Staff Rota
Free rota template Excel: four weeks for up to 15 staff, with rest and break checks under the Working Time Regulations and bank holidays for each UK nation.

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.




