A carpet cleaning technician's day is job time plus drive time between stops, repeating until the truck runs out of hours. Route capacity — how many jobs a technician can realistically book in a week — comes from dividing the workday by that job-plus-drive block, rounding down, and multiplying by days worked.
480 available minutes with a 55-minute job and 15-minute drive time fits 6 jobs a day — 30 a week over 5 days.
The example
Three technicians with different job lengths, drive times and days worked per week.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Tech | Avail min/day | Job min | Drive min | Days/wk | Weekly capacity |
| 2 | Tech 1 | 480 | 55 | 15 | 5 | 30 |
| 3 | Tech 2 | 480 | 40 | 10 | 6 | 54 |
| 4 | Tech 3 | 420 | 70 | 20 | 5 | 20 |
The formula
Jobs per day first, then scale to the week:
How it works
Three pieces combine:
C2+D2is the real time one job consumes on the schedule — the cleaning itself plus the drive to the next stop, 55+15=70 minutes.B2/(C2+D2)divides the workday by that block: 480 / 70 is 6.86 jobs.FLOOR(...,1)rounds down to 6, because the 0.86 of a job left over is not enough time to finish another full job and drive to the next one before the day ends.*E2multiplies the daily capacity by days worked per week to get the weekly total.
Compare weekly capacity against actual jobs booked — a route running consistently under capacity has room for more marketing; one running at or over capacity needs another truck before it needs more leads.
Try it: interactive demo
Enter available minutes per day, job length, drive time and days worked.
Variations
Different job length for a large-home job
Blend job minutes as a weighted average of your actual job-size mix (studio apartments clean faster than five-bedroom houses) rather than one flat number.
Second truck adds capacity linearly
Multiply weekly capacity by number of active trucks/technicians to see fleet-wide capacity rather than one route at a time.
Pitfalls & errors
Drive time should reflect the real average distance between stops on a route, not the shortest possible — a route built from scattered same-day bookings has longer average drive time than one built from a geographically clustered schedule.
Build in a buffer (do not schedule to exactly 100% of calculated capacity) — one job that runs long because of extra stain treatment eats into the buffer for the rest of the day, not just that appointment.
FLOOR requires a positive significance argument matching the sign of the number being rounded in older Excel versions; with `1` as the significance and a positive dividend this is never an issue here, but do not drop the significance argument to 0, which raises a #DIV/0! error.
Practice workbook
Frequently asked questions
Should lunch and administrative time count as available minutes?
How does this change for a route with back-to-back jobs in the same building?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class