Free template· UK, Excel, opens in Google Sheets

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.

rosterelf-uk-weekly-staff-rota.xlsx
The weekly staff rota filled in for an eight-person pub over Christmas week: start and finish times Monday to Friday, with AL, BH and OFF codes

File checked No signup

Only on this page

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.

StaffMonTueWedThuFriSatSunHours
Bola (Senior carer)NNNOFFOFFOFFOFF36
Tom (Carer)OFFOFFOFFNNNN48
Aisha (Nurse)DDOFFOFFDOFFOFF36
Megan (Carer)OFFOFFDDOFFDD48
Ryan (Zero-hours)DOFFOFFALOFFOFFOFF12

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

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
Download Excel (.xlsx)
FAQ

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)*24 so 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.

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