AEVOMIND INSIGHTS — OPERATIONS
Scheduling jobs and shifts in a spreadsheet: what it really costs

A spreadsheet rota is free to start and expensive to keep. In an illustrative business with 12 field staff, building the schedule, reshuffling it, telling people about changes and checking the rest rules by hand take about 6.7 hours a week; a scheduling system brings that to about 1.9, and can stop a pattern that breaks the 11-hour rest rule before anyone works it.
The short answer
A spreadsheet rota is free to start and expensive to keep. The cost hides in the week: an hour rebuilding next week’s schedule, fifteen minutes reshuffling every time someone is ill or a job overruns, and more again telling the people affected. None of it looks large on its own, and all of it comes back next week.
This article sets out where the hours go, the UK working time rules a schedule has to respect, the signs that a spreadsheet has had its day, and what AI can and cannot sensibly do for scheduling.
Where the hours go
- Building the schedule from jobs, availability, skills and locations held in several places.
- Reshuffling after changes — sickness, cancellations, overruns, urgent jobs — and working through the knock-on effects by hand.
- Telling people, one call or message at a time, and hoping the latest version is the one they read.
- Checking the rules, such as rest between shifts and average weekly hours, which a spreadsheet will not warn you about.

The arithmetic
Take an illustrative business with 12 field staff and six changes in a typical week. Each change takes about fifteen minutes to work through on a spreadsheet, and each affects three people who need telling, at around four minutes a message.
Illustrative inputs, not client data: 6 changes a week at 15 minutes each to reshuffle (5 with a system), each change told to 3 people at 4 minutes (automatic notifications, with 1 change in 6 still needing a call). Totals: 6.7 hours a week on a spreadsheet, 1.9 with a system.
Show the data
| Spreadsheet | Scheduling system | |
|---|---|---|
| Building next week’s schedule | 3.0 hrs | 1.0 hrs |
| Reshuffling after changes | 1.5 hrs | 0.5 hrs |
| Telling staff and customers about changes | 1.2 hrs | 0.2 hrs |
| Checking hours and rest rules by hand | 1.0 hrs | 0.2 hrs |
That comes to 6.7 hours a week on the spreadsheet against 1.9 with a scheduling system that re-plans, checks the rules and notifies people itself — about 4.8 hours back. Multiply by 4.33 for a month (about 20.8 hours) and divide by 162.5, the hours in one UK full-time month: roughly 0.13 of a full-time person.
The larger costs are harder to count and usually bigger: travel between badly ordered jobs, a missed appointment, an engineer sent without the right part. We look at those for installers in field service software for solar and heat pump installers.

The rules a schedule must respect
For adult workers, GOV.UK sets out three rest rights: a 20-minute break when the working day is longer than six hours, 11 hours’ rest between working days, and either 24 hours without work each week or 48 hours each fortnight. Separately, workers cannot work more than 48 hours a week on average, normally averaged over 17 weeks, unless they choose to opt out.
Derived arithmetic from GOV.UK rest breaks at work: 24 − 11 = 13. Adult workers; other limits, such as the 48-hour average week, still apply.
Show the data
| Value | Share | |
|---|---|---|
| Working day, at most | 13 hours | 54.2% |
| Daily rest, at least | 11 hours | 45.8% |
A late finish followed by an early start is the classic way a hand-made rota breaks the 11-hour rule without anyone noticing. A scheduling system can refuse to publish that pattern, or at least flag it, using the same compliance rules every time. Take your own advice on how the rules apply to your staff, especially for young workers and anyone who has opted out.

Signs it is time to switch
- Only one person can safely edit the schedule, and everything stops when they are away.
- Staff hear about changes late, or work from an old version.
- Double bookings, or jobs booked for someone on holiday, happen more than once a month.
- Nobody can say quickly whether next week’s pattern breaks the rest rules.
- Customers ring to ask when someone is coming, because nothing tells them.
Any two of these usually mean the spreadsheet costs more than it saves. The system that replaces it is operations and scheduling, with changes reaching people through staff mobile apps rather than a phone tree.
Where AI is heading
Scheduling is one of the places AI is genuinely useful: proposing a fair, efficient pattern and re-planning around a sick day in seconds. It is also where the fear of replacement is least borne out. Among UK businesses using AI to improve operations, the Office for National Statistics found 63.1% reporting no change in headcount and 6.2% a reduction — more than the 2.7% among businesses using AI for other purposes only, but still a small minority.
Source: Office for National Statistics, Artificial intelligence in UK businesses: 2023 to 2026 (July 2026), Business Insights and Conditions Survey. Open Government Licence v3.0. "Not sure" and "not applicable" responses are not shown, so columns do not sum to 100.
Show the data
| Use AI to improve operations | Use AI for other purposes only | |
|---|---|---|
| No change | 63.1% | 51.6% |
| Reduced headcount | 6.2% | 2.7% |
| Increased headcount | 1.1% | 1.8% |
The sensible pattern is that the system proposes and a person decides. AI needs accurate inputs — skills, locations, holidays, working time limits — and someone who knows the customers to make the final call. We discuss the wider question in can AI replace admin staff?

What scheduling should connect to
Scheduling software that stands alone becomes one more place to type the same information. It should read jobs from where they are booked, know who is on holiday from the HR system (see staff holiday tracking), push changes to people’s phones, and send hours worked to timesheets once. For field teams, that is the core of field service and mobile; for installers specifically, see software for installers.
Frequently asked questions
What does scheduling in a spreadsheet really cost?
More than it appears, because the time is spread across the week. In an illustrative business with 12 field staff, building the schedule, reshuffling it after changes, telling people about the changes and checking hours by hand come to about 6.7 hours a week. With a scheduling system that falls to about 1.9, roughly 4.8 hours saved a week, or 0.13 of a full-time person.
What working time rules must a staff schedule respect?
For adult workers, GOV.UK sets out a 20-minute rest break for days longer than 6 hours, 11 hours' rest between working days, and either 24 hours without work each week or 48 hours each fortnight. Workers cannot work more than 48 hours a week on average, normally averaged over 17 weeks, unless they opt out. A schedule should flag a breach before it is published.
When should a business stop scheduling in a spreadsheet?
When the schedule changes more than it stays the same. Common signs are one person who is the only one able to edit it, staff hearing about changes late, double bookings, jobs scheduled for someone on holiday, and nobody able to say quickly whether a shift pattern breaks the rest rules. Any two of these usually mean the spreadsheet is costing more than a system would.
Can AI do our job scheduling?
It can propose a schedule, but a person should still approve it. AI and optimisation tools are good at suggesting a fair, efficient pattern and re-planning around a sick day in seconds. They need accurate inputs, such as skills, locations, holidays and working time limits, and someone who knows the customers to make the final call.
What should scheduling software connect to?
To the system where jobs come from, so work is scheduled from the real order or booking; to holiday and absence records, so nobody is booked while away; to staff phones, so changes reach people instantly; and to timesheets or payroll, so hours worked are recorded once. Without these connections, a scheduling tool becomes one more place to type the same information.