A grooming calendar is really just open minutes divided into slots. Bigger dogs and heavier coats need longer slots than a quick small-breed trim, so a groomer's daily capacity depends on the average slot length they actually book, not an assumed standard appointment time.
480 open minutes at a 60-minute average slot is 8 appointments a day.
The example
Three groomers whose typical clientele runs different average sizes, and so different average slot lengths.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Groomer | Open minutes | Avg slot min | Slots/day |
| 2 | Groomer A (small breeds) | 480 | 60 | 8 |
| 3 | Groomer B (mixed) | 540 | 45 | 12 |
| 4 | Groomer C (large/double-coat) | 480 | 75 | 6 |
The formula
Open minutes divided by slot length, rounded down:
How it works
One division, one round-down:
B2/C2divides the workday by the average slot length — 480 minutes at 60 minutes a slot is exactly 8.FLOOR(...,1)rounds down to whole slots. Groomer B's 540/45 comes out to exactly 12 already, but a groomer averaging 47 minutes a slot in the same 540-minute day would round down from 11.49 to 11, not up to 12.
Build the actual appointment-time list from the slot count and opening time once you know daily capacity, the same way you would for any slot-based schedule.
Try it: interactive demo
Enter open minutes and the average slot length for this groomer's typical clients.
Variations
Average slot length from an actual appointment log
Rather than assuming one slot length, calculate the true average from a month of completed appointments so capacity reflects the groomer's real book, not an estimate.
Mixed slot sizes on the same calendar
If the calendar books explicit 30/45/60/90-minute slots rather than one average, sum a day's booked slot minutes directly and compare against open minutes instead of dividing by an average.
Pitfalls & errors
A dematting fee or a particularly matted coat can double a normal slot's length — if those are common at your shop, track a separate average slot length for "standard" versus "extra time needed" bookings rather than one blended average that understates true capacity.
Leave a buffer slot (or two) unbooked at the start of building the schedule — a groom that runs long by even 10 minutes cascades through the rest of the day if the calendar was booked to exactly 100% of calculated capacity.
If average slot minutes is ever 0 (a blank cell before real data is entered), the formula returns a #DIV/0! error. Default to a reasonable placeholder slot length, like 60 minutes, until real appointment data accumulates.
Practice workbook
Frequently asked questions
Should bathing-only appointments use the same slot length as a full groom?
How often should the average slot length be recalculated?
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