Dance Studio: Recital Run Time From The Routine Count

All versions

Every recital runs long, and it is never the dancing that does it. Thirty-four routines at two and a half minutes is 85 minutes of dance — but 34 blackouts, entrances, and prop changes add another 17, and the theatre charges by the hour.

Quick formula: Routines times the full slot, plus intermission:

=B2*(C2+D2)+E2

34 routines averaging 2.5 minutes with a 30-second transition and a 15-minute intermission is 117 minutes — just under two hours.

Functions used (tap for the full reference guide):

SUM PRODUCT

The example

Three show formats, each with a routine count, an average routine length, a transition allowance, and an intermission.

	A	B	C	D	E	F
1	Show	Routines	Avg min	Transition	Intermission	Run time
2	Spring recital	34	2.5	0.5	15	117
3	Competition showcase	22	3	0.75	10	92.5
4	Two-act finale	48	2.25	0.5	20	152

The formula

The transition belongs inside the parentheses:

=B2*(C2+D2)+E2 // each routine costs its length plus a transition; intermission is added once

How it works

Three numbers and one structural decision:

C2+D2 is what one routine really costs the clock: the music plus the blackout, entrance, and exit around it.
B2*(...) multiplies that by the program. Transitions scale with the routine count, which is exactly why long programs blow past their estimate.
+E2 adds intermission once. It is not per routine, so it must sit outside the multiplication.
Average routine length comes from the music files, not from memory. Two and a half minutes is typical for recreational classes; competition pieces run longer.

Compare the result against your theatre rental block and your youngest dancers' attention span. If it exceeds either, the fix is fewer routines or a second show, not a faster crew.

Try it: interactive demo

Interactive

Enter the routine count, average routine length, transition allowance, and intermission.

Routines

Avg routine (min)

Transition (min)

Intermission (min)

Variations

Routines that fit a fixed block

Flip it when the theatre gives you two hours and you have to cut the program to fit.

=ROUNDDOWN((120-E2)/(C2+D2),0)

Two acts, one intermission each

Split the routine count and add both breaks.

=B2*(C2+D2)+E2*2

Pitfalls & errors

Awards, speeches, and the finale bow are not routines but they are minutes. Add them as their own line rather than inflating the average, or the per-routine number stops being useful for cutting the program.

Time one real transition at dress rehearsal. Studios routinely assume 20 seconds and run 45, which on a 40-routine show is seventeen extra minutes.

Putting intermission inside the parentheses multiplies it by the routine count. The result looks absurd enough to catch, but the same mistake with a small per-routine fee is much harder to spot.

Practice workbook

📊

Download the free Dance Studio: Recital Run Time From The Routine Count practice workbook

Edit the yellow routines, average, transition, and intermission cells; run time recalculates.

Frequently asked questions

How long should a recital be?

Most studios aim for 90 to 120 minutes including intermission, largely because that is the limit for the youngest audience members and the youngest dancers waiting backstage. If the number here exceeds that, splitting into two shows usually costs less than the goodwill of a three-hour program.

Should I use average or total music length?

If you already have every track, sum the actual lengths instead of averaging and keep the transition multiplication. The average is only there for planning before the music is locked.

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: SUM PRODUCT