Free weekly staff rota template (Excel)
A weekly staff rota lists each person down the side and Monday to Sunday across the top, with a start and finish time or a code such as AL, BH or OFF in each day. This template works out each person’s weekly hours from the times, overnight shifts included, and totals each day.

Next week you’ll copy this sheet and type it again.
In RosterElf you import your staff from a CSV once, save the week as a rota template and publish it to everyone’s phone. Approved hours go to Xero UK or a CSV.
Your download has started.
A care home week: 12-hour days and nights
The second example: a small care home on 12-hour shifts, D for a day (08:00 to 20:00) and N for a night (20:00 to 08:00). The pub week above shows bank holiday and zero-hours codes; this one shows the rest gap between nights and days.
| Staff | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours |
|---|---|---|---|---|---|---|---|---|
| Bola (Senior carer) | N | N | N | OFF | OFF | OFF | OFF | 36 |
| Tom (Carer) | OFF | OFF | OFF | N | N | N | N | 48 |
| Aisha (Nurse) | D | D | OFF | OFF | D | OFF | OFF | 36 |
| Megan (Carer) | OFF | OFF | D | D | OFF | D | D | 48 |
| Ryan (Zero-hours) | D | OFF | OFF | AL | OFF | OFF | OFF | 12 |
Bola’s last night ends at 08:00 on Thursday. Moving her onto Thursday’s day shift would give her no rest at all; Thursday’s night, starting at 20:00, leaves 12 hours, which meets the 11-hour daily rest rule. Residential care can use an exception that allows compensatory rest instead, but the rota should still show the gap. The template does not check rest gaps for you: read them off the start and finish times before you publish. The rules are in our rota laws guide.
How to make a weekly rota in Excel
Four steps, if you would rather build your own. The template already has the grid, the formulas and the legend.
Set up the grid
Names in column A, roles in column B, then Monday to Sunday across the top. Freeze the panes so names stay visible as you scroll.Give each day a Start and a Finish column
Type 24-hour times (09:00, 17:00). A single cell such as 09:00–17:00 is text, and no formula can add it up. Add the totals
Work out each day with=MOD(Finish-Start,1)*24, which handles a night shift past midnight, add the seven days in a Total column and copy it down, then a daily total row underneath. Add a code legend
Agree what OFF, AL, BH, SICK and TOIL mean and write them on the sheet, or people will invent their own.What’s in the file
- A start and a finish time for each day, Mon to Sun
- Total hours per person and per day worked out by formula
- 15 staff rows, 8 with example names, and a notes column
- An Instructions tab with shift codes and working time reminders
More rota templates
Working time rules from GOV.UK: maximum weekly working hours and rest breaks at work. The file counts hours only; it does not work out pay.
Weekly rota FAQ
-
Put employee names down the left, the days of the week across the top, and shift times in the cells where they meet. Give each day a start and a finish time and total them with
=MOD(Finish-Start,1)*24so hours calculate themselves, and agree a set of codes for OFF, annual leave and bank holidays. The template above already has all of that. -
One row per person with their role, a start and finish time for each working day, a code for days off, holiday and bank holidays, and the week’s hours totalled. A care home example adds day and night shifts and checks the 11-hour rest between them. Both examples are shown on this page.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the layout and the formulas carry over. The same is true of LibreOffice Calc.
-
There is no general statutory minimum today: it is whatever the contract says. That is changing: the Employment Rights Act 2025 introduces a right to reasonable notice of shifts, expected in 2027. Our rota laws guide covers where the line sits now.
-
Use the BH code. Whether a bank holiday is extra leave or comes out of the 5.6 weeks depends on the contract. See our bank holiday guide.
Next week’s rota from this week’s, in one click
For when copying the sheet every week becomes the job.
Save a week as a template and copy it forward
- 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