A clinic’s capacity is appointment slots. Revenue per available slot — and per booked slot — shows how efficiently the schedule converts time into money.
The example
$9,600 over 80 slots.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 9600 / 80 | — |
| 3 | Per slot | → $120 |
The formula
The formula:
How it works
How it works:
- Divide total revenue by available slots for revenue per slot.
- Compare to revenue per booked slot (÷ slots filled) to isolate fill rate.
- Fill rate = booked ÷ available — how full the schedule runs.
- Lifting per-slot revenue (add-ons, fewer no-shows) grows income without more hours.
Two numbers, two problems. Low revenue per available slot but healthy revenue per booked slot means a scheduling/fill problem (empty slots) — market and reduce no-shows. Low revenue per booked slot means a monetization problem (small tickets) — add services. Splitting the metric points you at the right fix instead of guessing.
Try it: interactive demo
Revenue, available slots, booked slots.
Variations
Per booked slot
Filled only:
Fill rate
Booked ÷ available:
Revenue at full booking
Upside:
Pitfalls & errors
Available vs booked. Two different denominators — keep them distinct.
Define a slot. 15-min vs 30-min slots change the count.
Zero slots. No slots gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate revenue per appointment slot in Excel?
Why compare available vs booked slots?
What's my fill rate?
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