AEVOMIND INSIGHTS — OPERATIONS

Scheduling jobs and shifts in a spreadsheet: what it really costs

10 October 2026 · 8 min read · By the AevoMind team

A brass grid board of blank tiles with a gap where tiles have been lifted out, as two small figures restack them by hand beside a brass stylus

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

A black board of frosted-glass tiles, some glowing green and some topped with brushed gold markers, beside a stylus and notebooks
A schedule held in a system can check itself; a spreadsheet only holds whatever was typed into it.

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.

Where a spreadsheet rota’s week goesIllustrative business with 12 field staff: hours a week, spreadsheet versus a scheduling system
SpreadsheetScheduling system
Building next week’s schedule3.0 hrs1.0 hrs
Reshuffling after changes1.5 hrs0.5 hrs
Telling staff and customers about changes1.2 hrs0.2 hrs
Checking hours and rest rules by hand1.0 hrs0.2 hrs

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
SpreadsheetScheduling system
Building next week’s schedule3.0 hrs1.0 hrs
Reshuffling after changes1.5 hrs0.5 hrs
Telling staff and customers about changes1.2 hrs0.2 hrs
Checking hours and rest rules by hand1.0 hrs0.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.

A brass board of blank cards joined by a tangle of crossing threads, with small figures standing in front of it looking up
Every change made by hand pulls on threads elsewhere in the week.

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.

Every 24 hours, at least 11 must be restThe longest a working day can span, including breaks, once the 11-hour daily rest is respected
Working day, at most 13 hours · 54.2%Daily rest, at least 11 hours · 45.8%

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
ValueShare
Working day, at most13 hours54.2%
Daily rest, at least11 hours45.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.

A brushed gold disc-shaped desk clock with a plain face beside a neat stack of frosted-glass tiles on a black surface
Time is the scarce resource: the schedule should spend it on jobs, not on re-planning.

Signs it is time to switch

  1. Only one person can safely edit the schedule, and everything stops when they are away.
  2. Staff hear about changes late, or work from an old version.
  3. Double bookings, or jobs booked for someone on holiday, happen more than once a month.
  4. Nobody can say quickly whether next week’s pattern breaks the rest rules.
  5. 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.

Using AI for operations rarely means fewer staffAmong UK businesses using AI, reported effect on headcount, by whether they use AI to improve business operations, June 2026
Use AI to improve operationsUse AI for other purposes only
No change63.1%51.6%
Reduced headcount6.2%2.7%
Increased headcount1.1%1.8%

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 operationsUse AI for other purposes only
No change63.1%51.6%
Reduced headcount6.2%2.7%
Increased headcount1.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?

Three small figures each standing on their own brass tile of a grid in front of a model office, evenly spaced
The goal: the right person at the right job, with time to get there.

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.