Free template · Four teams · Three shifts

A 24/7 shift template that proves the coverage instead of claiming it

A 24/7 shift schedule covers every hour of every day without a gap, which takes three 8-hour shifts a day and four teams rotating through them. This template lays a 28-day Southern Swing onto real dates, and the sheet counts its own shifts per day so an uncovered hour shows up as a number rather than as a bad Sunday.

Free · No email address · No account

Where can I download a free 24/7 shift schedule template?

Here, and both buttons accept a start date and a timezone. No email address, no account, and no thank-you page with a sales sequence behind it.

Opens in Excel, Google Sheets, LibreOffice or Numbers. The printable version is laid out landscape for a wall.

What is in it

  • A full 28-day Southern Swing cycle for four teams, on real dates.
  • Three shifts a day that meet end to end, so there is no hour with nobody in it.
  • A real-hours column per shift, computed on elapsed time in the timezone you pick.
  • A shifts-per-day formula that keeps checking coverage as you edit the grid.
  • Per-team totals as formulas, so they stay right when you move somebody.

At a glance

  • A 24/7 schedule is a coverage requirement, not a pattern. It means 168 hours a week must have somebody in them, and the pattern is whatever you choose to satisfy that.
  • Four teams is the minimum that works without anybody living at the facility, and it lands every team on about 42 hours a week: 168 divided by four. No arrangement changes that total.
  • This template is a Southern Swing: seven days, two off, seven swings, two off, seven nights, three off, over 28 days. Days 07:00–15:00, swings 15:00–23:00, nights 23:00–07:00.
  • It rotates forward through the shifts, so every team carries an equal share of nights rather than two teams carrying all of them permanently.
  • The hours column is real elapsed time. An 8-hour night is 7 hours the night the clocks go forward and 9 the night they go back, and the sheet says so on the row.

What is a 24/7 shift schedule?

A 24/7 shift schedule is one where every hour of every day has somebody rostered onto it, including the hours nobody wants: three in the morning, Christmas Day, and the Sunday of a long weekend.

The phrase describes a requirement rather than a pattern, which is why searching for it returns so much noise. A hospital, a care home and a data centre all run 24/7 and none of them run the same roster. What they share is the constraint: the unit cannot close, so the question is never whether the hours get covered but who covers them and at what cost to the people doing it.

The arithmetic is unforgiving and it is the whole story. A week has 168 hours. If one person must be present at all times, that is 168 person-hours a week for a single post, and a full-time employee gives you about 37 to 42 of them. So a single continuously-covered post needs four people, not three, and the fourth is not slack — she is the reason the other three get days off, take holiday, and are allowed to be ill. Facilities that staff a 24/7 post with three people are not running lean; they are running a rota that only works while nobody's child gets chickenpox.

How many staff do I need to cover 24/7?

Four per post, and the number falls straight out of the arithmetic rather than out of anyone's preference: 168 hours a week divided by four teams is 42 hours each.

This is the calculation most worth doing before choosing a pattern, because it settles an argument people usually have much later and much more expensively. Take the number of hours the post must be covered, 168 for a genuine 24/7. Divide by the hours a person can sustainably work, call it 42 with some overtime in it. You get four. Add the second post and it is eight, and so on: every continuously-covered position costs you four heads, not three, and not 3.5 with agency filling the gap.

The pattern you pick after that changes almost nothing about the total and almost everything about how it feels. Three 8-hour shifts and four teams is 42 hours a week each. Two 12-hour shifts and four teams is also 42 hours a week each. The hours are identical; what differs is whether people work more days for shorter stretches or fewer days for longer ones, and whether the nights are shared out or concentrated onto the same faces forever.

Which is why the honest version of 'how many staff do I need' is a second question: how many do you need before the rota survives one person being ill? If the answer to the first is four and you have four, you do not have a 24/7 rota. You have a 24/7 rota and a plan to ring people on their day off.

What is the Southern Swing rotation?

A four-team, 28-day rotation of three 8-hour shifts: seven days, two off, seven swings, two off, seven nights, three off. Every team rotates forward through all three shifts and averages 42 hours a week.

It is the pattern this template generates, and it is the natural answer for a unit that has decided against 12-hour shifts. Three shifts meet end to end — days 07:00 to 15:00, swings 15:00 to 23:00, nights 23:00 to 07:00 — so the 24 hours close exactly, with a handover at each seam rather than a gap.

The rotation runs forward: days, then swings, then nights. That direction matters more than it sounds. A body adjusts to a later bedtime more easily than an earlier one, which is the same reason flying west is kinder than flying east, so rotating forward through the shifts asks less of people than rotating backward through them. It is a free improvement and a surprising number of rotas get it the wrong way round.

What it buys you

Everybody carries the same share of nights. On a fixed 12-hour pattern like the Pitman, two of your four teams are on nights permanently, and you have concentrated a real health cost onto half your staff in exchange for never asking the other half to adjust. The Southern Swing spreads it. Whether that is better is genuinely a question for the people working it, and it is worth asking them rather than deciding on their behalf.

What it costs

Seven consecutive nights, every cycle, for everyone. That is the trade: nobody is on nights forever, but everybody is on nights regularly, and each rotation asks the body to re-adjust rather than asking four people to adjust once and stay there. Rotating patterns are harder to sleep through than fixed ones, and the people who find the Southern Swing punishing tend to be the ones who would have been happy on permanent nights.

How this differs from the 12-hour template

It is the other answer to the same requirement. Our 12-hour template generates a Pitman: two shifts a day, four teams, fixed days and fixed nights, three-day stretches at most. This one is three shifts a day, four teams, everyone rotating. Both cover 24/7, both land on 42 hours a week, and neither is correct in the abstract. If your staff have already told you they will not work twelves, this is the sheet.

How many hours is an 8-hour night when the clocks change?

23:00–07:00 ≠ 8 hours

Seven the night the clocks go forward and nine the night they go back, for a shift the roster calls eight hours, on both occasions.

Subtract 23:00 from 07:00 and you get eight, on every date, which is exactly the problem: a wall clock is not a measure of elapsed time on the two nights of the year when the wall clock itself is edited while somebody is standing under it. In spring the hour between 02:00 and 03:00 does not happen, and the night shift that spans it is seven hours long. In autumn it happens twice and the same shift is nine. Nobody moved; the clock did.

The night shift is where this always lands, because 23:00 to 07:00 straddles the 02:00 boundary on both occasions. Every free 24/7 template on the web prints 8 in that column for all 28 rows, because the arithmetic that produced them subtracted one clock reading from another. Twice a year that is wrong, and it is wrong in a way that reaches a payslip: export eight for a nine-hour night and you have shorted somebody an hour of their life on the night they were least inclined to be generous about it.

The hours in the file are not typed. They are computed by the same engine that computes hours for a payroll export, working on instants and asking the operating system's timezone database rather than knowing anything about any government's rules — which is also why the file is correct in Arizona, where the column will read eight on every single row.

What this template cannot do

It can prove the pattern covers every hour. It cannot prove the people in it are allowed to work those hours.

The shifts-per-day formula is a real check and it keeps working as you edit, which is more than a static grid will do. But it is checking the shape of the rota, not the legality of the roster. It cannot know that the nurse you dropped into Tuesday's night has a licence expiring on Monday. It cannot enforce the rest gap between a nine-hour night and the swing somebody is on the next afternoon. It cannot notice that rotating a team forward through seven nights has pushed one person past a consecutive-days limit her contract sets. And when you re-key it into whatever runs your payroll, the nine-hour night will quietly become eight again, because eight is what everyone expects to see.

MedAligna computes every duration on real elapsed time for the same reason this file does, and then does the part a spreadsheet cannot: the rest rule, the credential check and the payroll export all read the same figure, so the night that ran nine hours reaches payroll as nine, and the person whose licence lapses on Monday cannot be put on Tuesday at all.

Questions people actually ask

How many people do I need to cover a post 24/7?
Four. A week is 168 hours, a full-time person sustainably gives you about 42, and 168 divided by 42 is four. Three people can cover the hours on paper only if none of them ever takes leave or falls ill, which is another way of saying three people cannot cover it.
What is the Southern Swing schedule?
A four-team, 28-day rotation of 8-hour shifts: seven days, two off, seven swings, two off, seven nights, three off. Each team rotates forward through all three shifts and averages 42 hours a week. It is what this template generates.
Is a 24/7 schedule better with 8-hour or 12-hour shifts?
Neither, in the abstract. Both land on 42 hours a week per team with four teams, because that is what the arithmetic forces. Twelves mean fewer, longer days and fewer handovers, usually with fixed nights for two teams. Eights mean more, shorter days and everyone sharing the nights. The people working it will have a clear opinion and it is worth asking them.
Why does the sheet count its own shifts per day?
Because a 24/7 rota has exactly one job and it is the job a spreadsheet is worst at proving. The formula divides the shift count by the number of days and should read 3. If you delete a row or move somebody and it reads 2.9, an hour of some day now has nobody in it, and you will find out from the formula rather than from the phone at 03:00.
Can I change the start date or the timezone?
Yes. Both links accept a start date and a timezone, and the roster and the hours are recomputed for whatever you ask for. Point it at the week of a clocks change and the notes column fills in.

Coverage that checks itself

MedAligna runs the rota against the rules on every change: rest gaps, credential expiry, consecutive days, and hours computed on real elapsed time. Fourteen days free, no card.