Revenue per hour measures a stylist’s productivity — service revenue over hours worked. It normalizes for schedule so a part-timer and a full-timer compare fairly.
The example
$2,400 over 30 hours.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 2400 / 30 | — |
| 3 | Per hour | → $80/hr |
The formula
The formula:
How it works
How it works:
- Divide service revenue by hours worked for productivity per hour.
- It normalizes for schedule — fairer than total revenue for comparing stylists.
- Use booked hours instead of scheduled to isolate productivity from gaps.
- Compare to the chair’s cost per hour to confirm each stylist covers their station.
Revenue per hour separates productivity from schedule. A stylist grossing $2,400 in 30 hours ($80/hr) is more productive than one grossing $2,800 in 40 hours ($70/hr), even though the second has higher total revenue. For pay decisions, coaching, and chair economics, the per-hour figure is the fair comparison — and dividing by booked rather than scheduled hours strips out the effect of empty slots.
Try it: interactive demo
Service revenue and hours worked.
Variations
On booked hours
Strip out gaps:
With retail
Total per hour:
Above chair cost?
Covers the station:
Pitfalls & errors
Scheduled vs booked. Booked hours isolate productivity; scheduled includes idle time.
Service vs total. Decide whether retail counts in the numerator.
Zero hours. No hours gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate revenue per hour for a stylist in Excel?
Should I use scheduled or booked hours?
How do I know if a stylist covers their chair?
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