A 60-minute massage does not take 60 minutes of the day. The client undresses and dresses, the sheets change, the therapist washes up and drinks water. That gap is turnover, and it decides how many sessions fit in a shift. Minutes open over session-plus-turnover, rounded down, is the real capacity; multiply by the price and you have the most one room can earn in a day.
An 8-hour day (480 min) with 60-minute sessions and 15 minutes of turnover: 480 ÷ 75 = 6.4, so 6 sessions — $570 at $95.
The example
Three rooms with different service menus. The 90-minute room sees fewer clients but a higher ticket; the 10-hour room with quick resets sees the most.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Room | Min open | Session min | Turnover min | Sessions/day | Price | Revenue/day |
| 2 | Room 1 (60-min) | 480 | 60 | 15 | 6 | $95 | $570 |
| 3 | Room 2 (90-min) | 480 | 90 | 15 | 4 | $130 | $520 |
| 4 | Room 3 (long day) | 600 | 60 | 10 | 8 | $95 | $760 |
The formula
Sessions first, then revenue:
How it works
The formula is short; the turnover number is the whole story:
C2+D2is the real slot length: 60 minutes of massage plus 15 of turnover is 75 minutes of room time per client.B2/(C2+D2)is how many of those slots fit in the day: 480 over 75 is 6.4.ROUNDDOWN(...,0)drops the 0.4. There is no such thing as 40% of a massage; the day holds 6.E2*F2multiplies by price: 6 sessions at $95 is $570, the most Room 1 can earn if every slot books.
Actual revenue is capacity times the booking rate. A room at 6 sessions and 70% booked averages 4.2 clients a day — run that as a separate column rather than lowering the capacity number.
Try it: interactive demo
Enter the minutes the room is open, the session length, the turnover between clients and the session price.
Variations
Leftover minutes
Minutes open minus the sessions that fit times slot length — 30 minutes in the example, enough for a chair massage or a real lunch.
Turnover needed to fit one more session
Solve for the gap that lets seven 60-minute sessions fit in 480 minutes: 480/7 − 60 ≈ 8.6 minutes. Usually the honest answer is "no".
Pitfalls & errors
Turnover is measured, not aspirational. Time five real changeovers including the client walking out and the next one walking in. Fifteen minutes is common; ten is tight; five is fiction.
Book on the slot length, not the session length. If your online scheduler offers 60-minute slots for 60-minute massages, you have scheduled zero turnover and the day will run late by the third client.
Do not include the therapist's lunch in minutes open. A 9-to-6 day is 540 minutes on the clock but 480 open if lunch is an hour.
Practice workbook
Frequently asked questions
Should the therapist's own break count as turnover?
How do I compare a 60-minute and a 90-minute menu fairly?
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