Bounce House: Base Plus Extra-Hour Fee

Excel Formulas › Bounce House Rental

All versions

A four-hour block covers most parties, but some run long. Bill the flat base for the block and charge only the hours past it, so a party that ends on time never subsidizes one that doesn't.

Quick formula: Base price plus any hours beyond the included block at the hourly rate:

=B2+MAX(0,D2-C2)*E2

A $175 base covers 4 hours; a 6-hour rental adds 2 hours at $35 for a $245 total. A 4-hour rental pays only the $175.

Functions used (tap for the full reference guide):

MAX

The example

Three rentals, each with a base price, the hours it includes, the hours actually booked, and the hourly overage rate.

	A	B	C	D	E	F
1	Rental	Base	Incl hrs	Hours	Hr $	Total
2	Combo	175	4	6	35	245
3	Slide	225	4	4	40	225
4	Castle	150	3	5	30	210

The formula

MAX keeps the overage from ever going negative when a party ends early:

=B2+MAX(0,D2-C2)*E2 // base, plus hours over the block x hourly (never below 0)

How it works

The MAX is the whole trick:

D2-C2 is how many hours the rental ran past the included block — which can be negative if it ended early.
MAX(0,...) floors that at zero so an early finish never creates a credit.
*E2 multiplies the extra hours by the hourly overage rate.
B2+... adds it to the flat base, so the base is always charged and only the overflow is metered.

Set the included block to match your standard party length — most rentals will land right at the base with no overage at all.

Try it: interactive demo

Interactive

Enter the base, the included hours, the hours booked, and the hourly overage rate.

Base ($)

Included hrs

Hours booked

Hourly ($)

Variations

Cap the overage

Never charge more than a full-day rate by capping the extra hours.

=B2+MIN(MAX(0,D2-C2),4)*E2

Delivery fee

Add a flat delivery-and-setup charge on top.

=B2+MAX(0,D2-C2)*E2+45

Pitfalls & errors

Without the MAX, a rental that ends an hour early subtracts an hour of pay from the base. MAX(0,...) is what stops a short party from discounting itself.

State the included block and the hourly overage on the contract. The formula enforces it, but the customer should see the block before the party runs long.

Practice workbook

📊

Download the free Bounce House: Base Plus Extra-Hour Fee practice workbook

Edit the yellow base, included, hours, and hourly cells; the total recalculates.

Frequently asked questions

Why floor the extra hours at zero?

Because D2-C2 goes negative whenever a rental ends before the included block runs out. MAX(0,...) turns that negative into zero, so an early finish is billed the flat base and nothing is subtracted.

Can I bill partial extra hours?

Yes — enter the hours as decimals (5.5 for five and a half) and the formula multiplies the fractional overage by your hourly rate automatically.

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

Function references: MAX