Splitting by hours is fairer than splitting evenly. Each valet's share is the pool times their share of total hours.
An $840 pool across 24 valet-hours pays $35 per hour; 6 hours earns $210.
The example
Three valets sharing one night's pool.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Case | Tips | My hrs | Total hrs | Share | Pool/hr |
| 2 | Valet Ana | $840.00 | 6.0 | 24.0 | $210.00 | $35.00 |
| 3 | Valet Ben | $840.00 | 8.0 | 24.0 | $280.00 | $35.00 |
| 4 | Valet Cy | $840.00 | 10.0 | 24.0 | $350.00 | $35.00 |
The formula
Share of hours times the pool:
How it works
Here is the logic, one piece at a time:
C2/D2is the valet's share of hours.- Multiplying by tips gives the share.
ROUNDrounds to cents.- The second formula divides pool by total hours.
Check that shares add to the pool.
Try it: interactive demo
Enter the pool, this valet's hours and total hours.
Variations
Check sum
Shares should total the pool.
Minimum floor
Guarantee a minimum.
Pitfalls & errors
Rounding can leave a cent or two off the total.
Total hours must include everyone sharing the pool.
Post the hourly pool rate.
Practice workbook
Frequently asked questions
What about cash vs card tips?
Unequal roles?
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