Measure Provider Utilization Hourly to Adjust Staffing

Measure provider utilization hourly to expose lost chair time

A practice can look busy on paper while losing productive chair minutes every day. To act on that loss you must measure provider utilization hourly: occupied minutes ÷ available minutes for each provider, for each clock hour. Hourly data shows where the schedule is underused (<60% occupied) and where providers run into bottlenecks (>85% occupied). From that you can make immediate staffing changes or adjust block schedules the next business day.

How to calculate utilization, step by step

Use the provider’s calendar for a given day and total, by hour, two values: occupied minutes and available minutes. Occupied minutes = sum of appointment minutes that overlap the hour. Available minutes = provider’s scheduled chair time in that hour (usually 60 minutes unless the provider blocks less for clinic or includes a scheduled break). Then apply the formula: occupied minutes ÷ available minutes = utilization rate for that hour. Example: 40 occupied minutes ÷ 60 available minutes = 67% utilization for the 9:00–10:00 hour.

What counts as occupied minutes and available minutes

• Occupied minutes: time the provider is booked with a patient (clinical appointment time). Exclude administrative blocks and lunch if those are not intended for patient care.
• Available minutes: minutes the provider is expected to provide chair time that hour. If a provider is scheduled for a 45-minute clinical block in an hour, available minutes = 45.
• If multiple operatories are assigned, calculate utilization per provider, not per operatory, unless your workflow assigns different chair resources to the same provider simultaneously.

Run an hourly utilization report and flag problem hours

Run the report for the most recent rolling 30 days and also for the same weekdays (e.g., all Mondays) to find consistent patterns. Produce an hourly matrix: rows = hours (8–9, 9–10, etc.), columns = providers, cells = utilization percentage. Flag cells that fall below 60% and above 85%. Save both daily and weekday-aggregate views so the team can see repeated issues versus one-off fluctuations.

1. Export or view the last 30 days of appointments by provider and compute occupied minutes per hour.
2. Normalize available minutes per provider-hour using the provider’s scheduled clinical blocks.
3. Color-code hours under 60% (low) and over 85% (high).
4. Identify hours that are low or high at least two-thirds of the weekdays for the same hour (e.g., three of four Mondays).

Translate hourly patterns into staffing actions the next business day

Hourly patterns map directly to operational fixes. Use the flagged hours to pick actions the team can execute immediately: call lists, reassign support staff, or change provider blocks. Below are the patterns to act on and the corresponding next-day steps.

If utilization is under 60% for an hour, take these immediate steps

• Open a same-day call list for that hour: pull the Daily Unbooked-Slot Outreach Script (slug: daily-unbooked-slot-outreach-script-fill-open-slots) and run a 3-step outreach cadence for last-minute patients.
• Shift front-desk or clinical assistant tasks into that hour to create capacity for short appointments (20–30 minutes). Make a list of patients appropriate for short slots—hygiene recare, post-op checks, simple repairs.
• If the low hour repeats on certain weekdays, reduce the provider’s scheduled clinical blocks on those days or split an hour into two shorter blocks to better match demand.
• Use the morning huddle to assign staff to execute the outreach and flag any barriers (staffing, phone capacity). See the morning-huddle action items (slug: morning-huddle-action-item-list-daily-patient-revenue-priorities).

If utilization is over 85% for an hour, use these immediate fixes

• Look for overflow patients queued to the next hour. Shift elective, longer appointments forward or backward to balance the provider’s load.
• Assign an assistant or float staff to the overloaded provider-hour to shorten turnover and reduce runover.
• If multiple providers show >85% for the same hour across weekdays, consider adding an extra provider block that day or opening an additional hygiene chair during that hour.
• Track runover minutes separately; repeated runover indicates you should adjust nominal appointment lengths or use a different block mix. Use the chair-turn target method to set per-hour appointment goals (slug: calculate-chair-turn-target-set-hourly-appointment-goals).

How to convert hourly patterns into block-schedule changes

Block schedules are rigid until you test edits. Make small, reversible changes and measure impact over two weeks. Common edits include changing a 3-hour block into 2×90-minute blocks, moving hygiene blocks to align with peak patient demand, or designating one daily open-list hour for same-day bookings. Use the hourly utilization matrix to pick which block(s) to change.

• If mornings 8–10 are consistently under 60%: move a provider’s start time later or convert one morning block to administrative time.
• If late afternoons 3–5 are >85%: add an additional hygiene or clinical block earlier in the day or extend office hours by one hour on specific high-demand days.
• If a single provider alternates low then high hours during a day: split large blocks so that appointment lengths better match demand variability within the day.

Daily operations: use hourly data in the morning huddle

Bring the prior day’s flagged hours into the morning huddle. Assign the following roles for the day: call/outreach owner for low hours, float/assistant assignment for high hours, and a runover monitor to track minutes that carry past the hour. Keep actions specific and time-boxed: who will call whom, how many patients to book, and who will shift tasks into open slots. See the morning-huddle action items for a 10-minute structure (slug: structure-10-minute-revenue-huddle-recover-missed-daily-revenue).

Metrics to track weekly to know if changes work

• Average hourly utilization per provider (track the same weekday over 4 weeks).
• Total unbooked chair minutes per day (sum of available minutes minus occupied minutes).
• Runover minutes per day and per provider.
• Number of same-day bookings filled from the call list for a flagged hour.
• Provider productive production per scheduled hour (use only as a follow-up metric after utilization stabilizes).

If unbooked chair minutes remain stubborn, translate those minutes into missed daily production using a standard appointment-value calculation and prioritize filling the highest-value minutes first. See Calculate Daily Missed Production to Recover Lost Chair Time (slug: calculate-daily-missed-production-recover-lost-chair-time) for that method.

Three operational pitfalls and how to avoid them

• Treating utilization as a single-number KPI: hourly granularity exposes where the number hides problems.
• Fixing peaks by constantly extending hours: instead, rebalance blocks and staff before adding time.
• Ignoring staff workload: if utilization increases without support, quality and retention suffer—plan assistant assignments with every scheduling change.

FAQ

Measuring provider utilization hourly turns an abstract staffing problem into named hours and actions. The work is simple: calculate occupied ÷ available, flag <60% and >85%, then run targeted outreach, staff shifts, or block edits. Use the morning huddle to assign owners and measure impact over two weeks.