Customers do not buy minutes, they buy laps — and the two are not interchangeable. A ten-minute arrive-and-drive session on a 34.5-second circuit is seventeen laps, and if your marketing says twenty, every session ends in an argument.
Ten minutes at 34.5 seconds a lap is 17 laps. The remaining 13 seconds are not a lap.
The example
Three session formats on the same track, each with its own length and its own realistic lap time for that kart class.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Session | Minutes | Avg lap sec | Laps |
| 2 | Adult sprint | 10 | 34.5 | 17 |
| 3 | Junior kart | 8 | 41.2 | 11 |
| 4 | Endurance heat | 20 | 33.8 | 35 |
The formula
Get both sides into seconds first:
How it works
Three things to get right:
B2*60converts the session to seconds, because lap times live in seconds and tenths./C2is the average lap for that class of kart. Junior karts on a shortened layout are not four seconds slower than adults, they are six or seven.ROUNDDOWN(...,0)because the chequered flag falls on a completed lap. A driver 80% around the circuit did not complete it.- Use average lap time, not best lap. The first two laps of a session are warm-up and the traffic laps are slow — a fast lap is a marketing number, not a planning one.
Advertise the honest number, or advertise minutes. Promising laps you cannot deliver is the single most common complaint in arrive-and-drive karting.
Try it: interactive demo
Enter the session length in minutes and a realistic average lap time.
Variations
Minutes needed for a promised lap count
Flip it when marketing sets the laps and you have to buy the clock.
Allow two warm-up laps
Subtract the laps that are not raced so the racing count is honest.
Pitfalls & errors
Lap time is not a track constant. A full grid in traffic runs several seconds slower per lap than a lone driver, so measure the average on a busy session.
Add the leftover seconds column. If sessions consistently end with 25 seconds spare, adding 20 seconds to the session buys an entire extra lap for free.
Do not round up to reach a rounder marketing number. Selling “20 laps” on a circuit that delivers 17 turns every session into a refund conversation.
Practice workbook
Frequently asked questions
Should I sell laps or minutes?
How do I get a reliable average lap time?
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