Ice time is billed by the hour and paid for by the skater, and those two facts collide the night only eight players show up. A minimum-roster floor is how teams handle it: the ice bill is divided by the actual count or the contracted minimum, whichever is larger, so nobody gets a $39 practice because their teammates were sick.
A $310 hour-and-a-half practice with only 8 skaters bills against the 12-player minimum — $25.83 each, not $38.75.
The example
Three sessions on the same sheet of ice, with a 12-skater contracted minimum.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Session | Ice rate | Hours | Officials | Skaters | Billed | Per skater |
| 2 | Team practice | $310 | 1.5 | $0 | 14 | 14 | $33.21 |
| 3 | League game | $310 | 1.5 | $130 | 16 | 16 | $37.19 |
| 4 | Squad practice | $310 | 1.0 | $0 | 8 | 12 | $25.83 |
The formula
The MAX is doing the interesting work; the rest is a division:
How it works
Four things go into the numerator and one decision into the denominator:
B2*C2is the ice itself. Rinks quote hourly and sell in half-hour or hour blocks, so hours belongs in its own cell rather than being folded into the rate.+D2adds officials, which apply to games and not to practices. Keeping it as a column means one sheet covers both kinds of session.MAX(E2,$B$9)is the floor. If 8 skaters show up on a 12-minimum contract, the bill is split 12 ways and the team absorbs the difference — which is the point of agreeing a minimum in the first place.ROUND(...,2)to cents, because this number goes straight onto a payment request and people will check it.
Keep the minimum in one cell rather than typing 12 into every formula. Rosters change between seasons and the whole sheet should follow from one edit.
Try it: interactive demo
Enter the ice rate, session length, officials fee, and how many skaters turned up.
Variations
Season cost per skater
Multiply by the number of sessions in the season. That is the figure a parent needs before committing, and it is always larger than they expect.
What the thin night actually cost the team
The gap between the floored bill and the true split is the shortfall the team absorbs. Worth tracking across a season.
Pitfalls & errors
A minimum roster only works if it is in writing before the season. Applying a floor retroactively to a night that went badly is how team treasurers lose friends.
Goalies are frequently excluded from the split or charged at a reduced rate. If that is your policy, take them out of the skater count and add their contribution to the numerator instead.
Do not use MIN by mistake. MIN(E2,$B$9) caps the head count at 12, so a 16-skater game gets billed as 12 and the team comes up short every single time it is well attended.
Practice workbook
Frequently asked questions
What is a reasonable minimum roster?
Should coaches be counted in the skater number?
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