HR
Workforce
Payroll
Across the platform
By industry
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
How to use the rota template
- Enter your business or site and the Monday the week starts. The day headings fill in by themselves.
- List each employee with their role and hourly rate.
- For each shift, enter a start time, a finish time and the unpaid break in minutes. Leave days off blank.
- 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.