Shuttle work is not billed by the guest, it is billed by the clock — and the clock is set by how many round trips one bus has to make. Guests divided by seats gives trips; trips times the loop gives the minutes you have to start before the ceremony.
120 guests on a 28-passenger bus is 5 trips — not 4.3 — and at a 34-minute loop that is 170 minutes of shuttle.
The example
Three shuttle runs, each with a guest count, a bus, a one-way drive, and a realistic load-and-unload allowance.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Run | Guests | Seats | One-way min | Load min | Trips | Total min |
| 2 | Hotel to venue | 120 | 28 | 12 | 10 | 5 | 170 |
| 3 | Airport block | 200 | 40 | 18 | 12 | 5 | 240 |
| 4 | After-party | 75 | 24 | 9 | 8 | 4 | 104 |
The formula
Two columns, because the trip count is worth seeing on its own:
How it works
Follow the bus:
ROUNDUP(B2/C2,0)is the trip count. Seats are a hard ceiling, so 4.3 trips is 5 trips — the last 8 guests still need a ride.2*D2is the driving half of the loop: out to the venue and back for the next load. A one-way estimate is the single most common way to under-quote a shuttle.+E2is the part crews forget. Loading 28 people in formalwear is not instant; 8–12 minutes per cycle is realistic.- Multiply and you have the total shuttle window. Subtract it from the ceremony time to get the moment the first bus pulls up at the hotel.
Note the last loop does not need a return leg. If you are quoting garage-to-garage hours you keep it; if you are telling the couple when guests are seated, subtract one D2.
Try it: interactive demo
Enter the guest count, the seats on the bus, the one-way drive, and the load allowance.
Variations
Two buses running
Split the trips across vehicles and the window collapses roughly in half.
Drop the final return leg
The last bus stays at the venue, so the final trip is one-way.
Pitfalls & errors
Do not use average guest arrival to shrink the trip count. Shuttles are judged by the last guest, and the last guest rides the last bus.
Add a trip when the hotel block is spread across two properties. Two pickup points is a longer loop, not the same loop with more people.
Rounding the trip count down is the failure mode here. =ROUND(120/28,0) returns 4 and strands 8 guests in a lobby.
Practice workbook
Frequently asked questions
How do I turn this into billable hours?
What load allowance should I use?
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