Free template· UK, Excel, 4 sheets

Free rolling rota template (4 on 4 off)

A rolling rota repeats one shift pattern on a fixed cycle instead of being written fresh each week. This template has two worked patterns for 24/7 cover: 4-on-4-off across four teams on a 16-day cycle, and continental 2-2-3 on a 14-day cycle with every other weekend off, each with a cover count under every day.

rosterelf-uk-rolling-rota.xlsx
The 4-on-4-off sheet of the rolling rota template: four teams offset by four days, day and night blocks, and two teams on shift every day

File checked No signup

The download

What’s in the file

  • A 4 on 4 off tab: four teams on days and nights over 28 days
  • A Continental 2-2-3 tab with the same four teams
  • An On shift row counts the teams working each day, by formula
  • A blank Your pattern tab to build your own cycle
Download Excel (.xlsx)
Only on this page

Which rolling pattern suits you?

Both patterns give 24/7 cover with four teams. On 12-hour shifts both average 42 hours a week, under the 48-hour average before any overtime.

4 on 4 offContinental 2-2-3
Cycle16 days: 4 days, 4 off, 4 nights, 4 off14 days: 2 on, 2 off, 3 on, then the mirror image
TeamsFour, offset by four daysFour: two on days, two on nights
WeekendsRotate through the cycleEvery other weekend off
Hours a week on 12-hour shifts42 on average42 on average
Watch forThe night-to-day changeoverFixed nights for two teams

The 11-hour daily rest rule is where rolling patterns go wrong: the cycle itself is fine, but a swap that puts someone from a night onto a day shift the same day is not. The shift patterns guide also covers Panama and DuPont.

FAQ

Rolling rota FAQ

  • Four shifts worked, then four days off, repeating. For 24-hour cover it runs as a 16-day cycle (four day shifts, four off, four night shifts, four off) with four teams each offset by four days, so two teams are always on and two are always off. The template has it worked out.

  • Four teams for continuous 24/7 cover with one day team and one night team on at all times. The size of each team depends on your minimum staffing level per shift, not on the pattern itself.

  • Any pattern that repeats every 28 days. Both patterns in this template are shown across four weeks so you can see the cycle land back where it started, which is the point at which you know it is genuinely repeating.

  • They can. 4-on-4-off on 12-hour shifts averages 42 hours a week, which is fine, but overtime on top can push someone over. The limit is a 48-hour average, normally over 17 weeks. See our rota laws guide.

  • Overlay AL on top of the pattern and backfill from the off-going team. Holiday entitlement is still 5.6 weeks; on 12-hour shifts it is usually cleaner to track it in hours than in days. See our holiday entitlement guide.

In RosterElf

Next week’s rota from this week’s, in one click

For when copying the sheet every week becomes the job.

A café worker beside RosterElf’s Select a roster to copy panel, with last week’s roster ready to copy

Save a week as a template and copy it forward

Any weekCopy last weekStaff app
  • Save any rota as a reusable template
  • Copy last week’s rota instantly
  • Clone individual shifts across days
  • Staff see their shifts on the iPhone and Android app