# How to Make a Staff Rota: Rules, Cover, Spreadsheet or App

> To make a staff rota, work out cover needed per hour, collect availability and requests, choose a repeating shift pattern, fill it in, check it against working time rules and publish it early. In the UK that means 11 hours' rest between shifts, a 20-minute break for shifts over six hours and a weekly rest day.

- URL: https://personaloptimierer.de/en/hr-processes/how-to-make-a-staff-rota/
- Language: en
- Updated: 2026-10-19
- Publisher: Personaloptimierer (OnlineBuilders LLC, https://onlinebuilders.biz)

A rota is a compromise between three things that rarely fit together: what the business needs, what working time law allows and what people want. Plan only for demand and you break rest rules. Plan only for preferences and nobody is on the till on Saturday night. Start from a blank sheet every month and you lose a day to a spreadsheet that's out of date by Wednesday.

What follows walks through rota planning the way it happens in practice and brings in the rules at the point where they matter. The examples use UK law, with notes on the US and Germany where they differ.

## Step 1: Work out the cover you really need

The rota starts with numbers, not names. How many people do you need, at which hour? The answer depends on opening hours, customer flow and minimum staffing for safety.

Turning hours into headcount is where many plans go wrong. Full-time staff aren't available 52 weeks a year. UK statutory holiday is 5.6 weeks, which is 28 days for a five-day week. That alone removes almost 11% of working days. Sickness comes on top.

**Example: headcount for a shop floor**

- Cover hours: 6 days × 12 hrs × 2 people: 144 hrs/week
- Full-time equivalents on paper: 144 ÷ 37.5: 3.84
- Absence factor: 1 ÷ (1 − 0.108 − 0.04): × 1.17
- **Headcount including absence: about 4.5 FTE**

Illustrative assumptions: open Mon–Sat 8am–8pm, two people at all times, 37.5-hour contracts, 28 days' holiday (10.8%), 4% sickness assumed.

Plan with 3.84 people and you are short from day one. That explains a lot of rotas that need patching every week.

## Step 2: Know the working time rules

Before any names go in, be clear on the limits. In Great Britain, the Working Time Regulations 1998 set the framework for adult workers.

**UK working time rules: the rota check**

- [ ] Average of no more than **48 hours a week**, usually over 17 weeks, unless the worker has opted out in writing
- [ ] A **20-minute** uninterrupted break when working more than 6 hours a day
- [ ] **11 hours** of rest between working days
- [ ] **24 hours** off each week, or 48 hours each fortnight
- [ ] Night workers: no more than an average of 8 hours in 24
- [ ] Under-18s: 30-minute break after 4.5 hours, 12 hours' daily rest, 2 days off a week, 8 hours a day and 40 a week at most

The government summary of rest breaks is on [GOV.UK](https://www.gov.uk/rest-breaks-work). Contracts can give more generous rights, and some sectors have their own rules.

The 11-hour rest is the rule most often broken in practice. Someone finishing a late shift at 10pm should not start again before 9am. The classic culprit is a "clopen", a closing shift followed by an opening shift.

Other countries differ. Germany caps the working day at 10 hours and requires 30 minutes' break after six hours. Federal US law sets no daily limits for adults, but predictive scheduling laws in Oregon and several cities require advance notice and extra pay for late changes in certain sectors.

## Step 3: Collect availability and requests

Ask for requests by a fixed date, for example the 10th of the month before, and in one format. Requests by WhatsApp, in passing and on sticky notes are why planners forget someone.

Separate preferences from fixed constraints. A part-timer contracted for mornings only is not a preference. A colleague who would like Saturdays off is. Treat both the same and you lose track, and eventually the team's trust.

A simple fairness rule helps. Requests that weren't met last time get priority this time. One extra column in the spreadsheet is enough.

## Step 4: Use a pattern, not a blank page

Planning each week from scratch takes half a day every time. Setting a base pattern, such as a four-week rolling rota, means you only edit the exceptions. Occupational health guidance generally favours forward-rotating patterns, earlies then lates then nights, because the body copes better with a later start than an earlier one.

The right pattern depends on the operation. A shop with two shifts can run a fixed weekly rhythm. A care service covering 24 hours needs a longer rotation.

## Step 5: Check before you publish

Read the finished rota per person, not top to bottom. When does each shift end, when does the next begin? Are weekly hours in line with the contract? Has anyone got seven days in a row? Rota software does this automatically. With a spreadsheet you need a helper column.

If each row holds one shift for one person, with the start in column B and the end in column C as date and time, this formula in row 3 gives the rest since the previous shift in hours:

`=(B3-C2)*24`

Conditional formatting that turns anything under 11 red shows breaches at a glance. It only works if the sheet is sorted by person and then by date. That sounds obvious. It is also the most common reason such checks fail.

## Step 6: Publish early and manage changes

Two weeks' notice is a good default, and in some US jurisdictions it is the legal standard. The earlier the rota is out, the fewer swap requests you get.

In Germany, works councils co-determine the start and end of working hours and breaks, and courts extend this to each individual rota unless a framework agreement exists. If you run German sites, that framework agreement saves both sides a great deal of time. More on that in [works councils and IT systems](https://personaloptimierer.de/en/law-and-works-councils/works-council-it-systems/).

## The most common rota mistakes

Planning with budgeted posts instead of available hours. A rota that only works when nobody takes holiday never works.

Swaps that break the rest rule. The original plan is usually fine. The breach happens when two people swap a Friday late and a Saturday early. Run every swap through the same check.

Holiday for irregular hours. UK workers with irregular hours or part-year contracts accrue holiday at 12.07% of hours worked for leave years starting on or after 1 April 2024. If your rota relies on them, record actual hours carefully, or the holiday calculation will be wrong.

Rotas only the planner understands. Abbreviations, colours without a key and handwritten edits on the printout lead to people turning up at the wrong time.

## Spreadsheet or rota app?

The honest answer depends on team size.

**Spreadsheet or rota software**

| | Spreadsheet | Rota software |
|---|---|---|
| Cost | none extra | usually per user per month |
| Automatic rest-period check | with formulas, error-prone | yes |
| Shift swaps by staff | no | yes |
| Mobile access for staff | partly | yes |
| Link to time tracking | no | usually yes |
| Sensible up to roughly | 10 people, fixed shifts | several teams or sites |

Time tracking is a growing argument for software. EU employers are required to record working time, and Germany is moving towards electronic recording, see [time tracking law in Germany](https://personaloptimierer.de/en/law-and-works-councils/time-tracking-law-germany/). Planned and actual hours in one system save the reconciliation. If standard tools can't model your shift logic, for instance with several pay agreements or qualification rules per shift, a studio like [OnlineBuilders](https://onlinebuilders.biz/solutions/software-development) can build a planning tool. Most teams will do fine with an off-the-shelf product.

Your next step: recalculate your team's headcount with the absence factor from step 1 and compare it with the people you actually have. More guides are in the [HR processes section](https://personaloptimierer.de/en/hr-processes/), including [HR process automation](https://personaloptimierer.de/en/hr-processes/hr-process-automation/).

## FAQ

### How much notice should staff get of their rota?

UK law sets no general minimum notice for rotas, although contracts and collective agreements often do. Several US jurisdictions, including Oregon and cities such as Seattle and New York for certain sectors, require around two weeks' notice. Two weeks is a sensible default anywhere.

### Can I change a rota after publishing it?

Usually, within the limits of the contract and reasonableness. Last-minute changes damage trust quickly, and in places with predictive scheduling laws they can trigger extra pay. In Germany, a works council must agree to changes unless a framework agreement allows them.

### What are the break rules for under-18s?

Young workers in the UK are entitled to a 30-minute break if they work more than four and a half hours, 12 hours' rest between working days and two days off each week. They normally cannot work more than eight hours a day or 40 hours a week.

### Is a spreadsheet good enough for a rota?

For a team of up to about ten people on fixed shifts, often yes. Once shift swaps, multiple sites or time tracking come in, rota software usually costs less than the hours lost in spreadsheets.

Photo: Claudio Elias, Public domain (https://commons.wikimedia.org/wiki/File:WallCalendar.jpg)