A wedding reception that books a 3-hour photo booth package and runs 15 minutes long owes an overtime fee — but billing that in exact minutes looks fussy on an invoice. Most rental businesses bill overtime in clean 15-minute increments instead: round the overage up to the next quarter-hour, then apply the hourly overtime rate to that.
15 minutes over a 180-minute package rounds to a 15-minute block — a quarter of the $120 hourly rate, or $30.
The example
Three events, each running past their booked package length by a different amount.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Event | Actual min | Package min | Rate/hr | Overtime fee |
| 2 | Garcia wedding | 195 | 180 | 120 | $30.00 |
| 3 | Corp holiday party | 140 | 120 | 150 | $75.00 |
| 4 | Sweet 16 | 250 | 240 | 100 | $25.00 |
The formula
MAX keeps a normal early finish from producing a negative fee; CEILING enforces the billing increment:
How it works
Four steps nested together:
B2-C2is raw minutes over the package — 195 actual minus 180 booked is 15 minutes over.MAX(0,...)floors that at zero, so an event that ends early (a negative difference) never produces a negative or refundable overtime fee.CEILING(...,15)rounds the overage up to the next 15-minute increment. 15 minutes is already an exact block, so it stays 15; 4 minutes over would round up to a full 15-minute block too./60*D2converts the billed minutes to hours and applies the hourly overtime rate — 15 minutes is a quarter hour, times $120 is $30.
Show the billed block, not just raw minutes over, on the invoice — it is the number that explains why 4 minutes late costs the same as 14.
Try it: interactive demo
Enter actual minutes, package minutes and the hourly overtime rate.
Variations
Bill in 30-minute blocks instead of 15
Change the CEILING significance to match your actual contract terms — some vendors bill overtime in half-hour blocks rather than quarter-hour.
Flat overtime fee instead of pro-rated
Some contracts charge one flat fee for any overage at all rather than scaling with how late the event ran — a simple IF replaces the CEILING math entirely.
Pitfalls & errors
Quote the overtime rate and billing increment in the original contract, in writing, before the event — a surprise 15-minute-block policy at 1am after a wedding runs long is a bad time to explain it for the first time.
MAX(0,...) is easy to forget and easy to not notice is missing, because most events do not run early. Test the formula with an actual-minutes value below the package minutes to confirm it returns $0, not a negative number.
CEILING's second argument (the significance) must share the same sign as the first argument once negatives are possible. Since MAX(0,...) already guarantees a non-negative overage here, this is safe — but removing the MAX wrapper would reintroduce the risk.
Practice workbook
Frequently asked questions
What if the venue, not the client, causes the event to run long?
Should setup and teardown time count toward the package minutes?
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