Trampoline Park: Sessions That Fit In A Day

All versions

A 60-minute session does not consume 60 minutes of the day. Clearing the courts, checking grip socks, and running the safety briefing eat the gap between slots, and a timetable built without that gap runs late by lunchtime.

Quick formula: Open minutes divided by the full slot, rounded down:

=ROUNDDOWN(B2/(C2+D2),0)

A ten-hour day with 60-minute jumps and a 10-minute changeover is eight sessions, not ten.

Functions used (tap for the full reference guide):

ROUNDDOWN SUM

The example

Three operating patterns, each with its open window, jump length, and the changeover the floor staff actually need.

	A	B	C	D	E
1	Day type	Open min	Jump min	Changeover	Sessions
2	Weekday	600	60	10	8
3	Long-session Sat	480	90	15	4
4	Holiday express	720	60	5	11

The formula

The denominator is a slot, not a session:

=ROUNDDOWN(B2/(C2+D2),0) // jump + changeover = slot, into open minutes, rounded down

How it works

Three inputs, one of them usually wrong:

B2 is the open window in minutes. Count from the first slot start to the last possible slot end, not from staff arrival.
C2 is the jump time you sell. This is the number on the ticket.
D2 is changeover: clearing the court, sweeping, checking socks, and running the briefing for the next group. Time it once with a stopwatch — it is almost never five minutes.
ROUNDDOWN(...,0) because a partial session cannot be sold. The leftover minutes belong to the closing crew.

Multiply sessions by jumpers per session and by ticket price and you have the day's revenue ceiling — the number every staffing decision should be measured against.

Try it: interactive demo

Interactive

Enter the open window, the jump time you sell, and a realistic changeover.

Open minutes

Jump minutes

Changeover minutes

Variations

Revenue ceiling for the day

Sessions times capacity times ticket price is the most the floor can produce.

=ROUNDDOWN(B2/(C2+D2),0)*60*18

Staggered courts

Two courts starting on an offset double the slots without shortening the changeover.

=ROUNDDOWN(B2/(C2+D2),0)*2

Pitfalls & errors

Changeover is not a constant across the day. A birthday-party block hands the court off far more slowly than a walk-in session, so give party days their own row.

If the leftover minutes at the end of the day are close to a full slot, shaving two minutes off changeover can buy an entire extra session. The demo shows the leftover so you can see how close you are.

Do not build the timetable from ROUNDUP. Publishing nine slots in a day that only fits eight guarantees the last group is cut short.

Practice workbook

📊

Download the free Trampoline Park: Sessions That Fit In A Day practice workbook

Edit the yellow open-minutes, jump, and changeover cells; the session count recalculates.

Frequently asked questions

Should the first slot start at opening time?

Rarely. Most parks give themselves one changeover before the first session for court checks and waiver processing. Subtract it from the open window rather than adding a fake slot.

What about overlapping sessions?

If groups can enter while others are still jumping, the slot length is the entry interval, not the session length. Replace the denominator with your interval and the same formula works.

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

Function references: ROUNDDOWN SUM