Go-Kart Track: Laps A Session Actually Delivers

Excel Formulas › Go-Kart Track

All versions

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.


Quick formula: Minutes to seconds, divided by a lap, rounded down:
=ROUNDDOWN(B2*60/C2,0)

Ten minutes at 34.5 seconds a lap is 17 laps. The remaining 13 seconds are not a lap.

Functions used (tap for the full reference guide):

The example

Three session formats on the same track, each with its own length and its own realistic lap time for that kart class.

ABCD
1SessionMinutesAvg lap secLaps
2Adult sprint1034.517
3Junior kart841.211
4Endurance heat2033.835

The formula

Get both sides into seconds first:

=ROUNDDOWN(B2*60/C2,0) // minutes x 60 = seconds, / lap seconds, rounded down

How it works

Three things to get right:

  1. B2*60 converts the session to seconds, because lap times live in seconds and tenths.
  2. /C2 is 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.
  3. ROUNDDOWN(...,0) because the chequered flag falls on a completed lap. A driver 80% around the circuit did not complete it.
  4. 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

Interactive

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.

=ROUNDUP(20*C2/60,0)

Allow two warm-up laps

Subtract the laps that are not raced so the racing count is honest.

=ROUNDDOWN(B2*60/C2,0)-2

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

📊
Download the free Go-Kart Track: Laps A Session Actually Delivers practice workbook
Edit the yellow minutes and lap-time cells; the lap count recalculates.

Frequently asked questions

Should I sell laps or minutes?
Minutes are safer operationally because they keep the timetable fixed regardless of traffic; laps sell better because customers understand them. Many tracks advertise minutes and post the typical lap count next to it, which is exactly what this column produces.
How do I get a reliable average lap time?
Pull a week of timing-system data and average every lap, including the slow ones. Excluding out-laps and traffic laps produces a number your customers will never experience.

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

Related formulas: Speed and Pace Conversion · Trampoline Park: Sessions That Fit In A Day · Cycle Time vs Takt Time

Function references: ROUNDDOWNPRODUCT