Cookie preferences

Analytics and marketing cookies are on unless you switch them off here. Read the cookie policy.

Strictly necessary Always on

Needed for the site to work, such as security and remembering your cookie choice.

Help us understand which pages are useful and which companies visit our site, so we can improve it.

Used to measure our adverts and show relevant adverts on other sites.

A free staff rota template that adds up hours and cost.

This staff rota template is an Excel file for planning a week of shifts. Enter start and finish times and breaks, and it works out each person’s hours and the cost of the week, including shifts that run past midnight.

Last updated November 2026

Staff rota template

  • A weekly rota for up to 30 people, Monday to Sunday
  • Start, finish and unpaid break for every shift
  • Hours and labour cost per person and for the week
  • Night shifts counted correctly, for example 22:00 to 06:00
  • A how-to sheet and a reminder of the rest break rules
Download the rota template

Excel file, 14 KB. Free, no form to fill in.

How to use the rota template

  1. Enter your business or site and the Monday the week starts. The day headings fill in by themselves.
  2. List each employee with their role and hourly rate.
  3. For each shift, enter a start time, a finish time and the unpaid break in minutes. Leave days off blank.
  4. Hours and cost work themselves out. Copy the sheet for each new week.

Working time rules to check on every rota

Workers are entitled to a rest break of at least 20 minutes when they work more than 6 hours in a day, and to 11 hours’ rest between working days. Source: GOV.UK rest breaks at work.

Workers cannot work more than 48 hours a week on average, normally averaged over 17 weeks, unless they opt out. Source: GOV.UK maximum weekly working hours. Our working hours calculator checks a week against these rules.

When the spreadsheet stops keeping up

In Givver, rotas are built with leave and labour cost already in view, staff see their shifts and swap or pick up open shifts in the Givver app, and every shift is paid from approved time.

See rota software →   See time and attendance →   Talk to sales →

Questions about the staff rota template

What should a staff rota template include?

Each person’s name and role, the start and finish time of every shift, unpaid breaks, and the total hours for the week. This template also works out labour cost from each person’s hourly rate.

Can I use it as a weekly rota planner?

Yes. Plan each week’s shifts on a copy of the sheet, and the hours and cost for the week update as you go.

Is the rota template free?

Yes. Download it and use it as often as you like. There is no form to fill in.

Does the rota template work for night shifts?

Yes. A shift that finishes after midnight, such as 22:00 to 06:00, is counted correctly, less any unpaid break.

What does the cost column include?

Hours worked times the hourly rate you enter. It does not include holiday pay, employer National Insurance or pension contributions.

More free templates and tools

This template is general guidance, not legal advice. Check it against GOV.UK and adapt it to your business.

Rotas, leave and contracts on one employee record.

See how Givver would work for your team.

Talk to sales