Portable Toilet Rental: Units For an Event

Excel Formulas › Portable Toilet Rental

All versions

One portable toilet comfortably serves about 50 guests for a four-hour event — that is 200 guest-hours per unit. Multiply guests by hours, divide by 200, and round up to the units the event needs.

Quick formula: Guest-hours divided by 200 per unit, rounded up:

=ROUNDUP(B2*C2/200,0)

A 120-guest, 5-hour wedding is 600 guest-hours — three units.

Functions used (tap for the full reference guide):

ROUNDUP

The example

Three events, each with a guest count and a run time in hours.

	A	B	C	D
1	Event	Guests	Hours	Units
2	Wedding	120	5	3
3	Festival	500	8	20
4	5K race	300	3	5

The formula

Guests times hours is the demand; 200 is the guest-hours one unit handles:

=ROUNDUP(B2*C2/200,0) // guest-hours / 200 per unit, rounded up

How it works

Three moves:

B2*C2 multiplies guests by hours to get guest-hours — the real driver, since a longer event needs more units for the same crowd.
/200 divides by the guest-hours one standard unit serves (about 50 guests for 4 hours).
ROUNDUP(...,0) rounds up, because a partly-used unit is still a whole unit you have to place.
Adjust the 200 for your standard: alcohol service and no nearby restrooms push it lower.

Add units for accessibility and hand-washing separately — codes often require at least one ADA unit regardless of the headcount math.

Try it: interactive demo

Interactive

Enter the guest count and how many hours the event runs.

Guests

Hours

Variations

Alcohol served (heavier use)

Drink service raises usage — divide by 150 guest-hours per unit instead of 200.

=ROUNDUP(B2*C2/150,0)

Add one ADA unit

Guarantee at least one accessible unit on top of the count.

=ROUNDUP(B2*C2/200,0)+1

Pitfalls & errors

Sizing by guests alone ignores duration. A 200-guest, 8-hour event needs far more units than a 200-guest, 2-hour one — guest-hours captures that; a headcount rule does not.

These are planning rules, not code. Check the local health department and any venue or permit requirements, which may set a hard minimum higher than the math.

Practice workbook

📊

Download the free Portable Toilet Rental: Units For an Event practice workbook

Edit the yellow guest and hour cells; the units to place recalculates.

Frequently asked questions

Where does 200 come from?

It is the common planning figure of one unit per 50 guests for a 4-hour event: 50 x 4 = 200 guest-hours. Longer or heavier-use events lower that number per unit.

Does this replace a permit check?

No. Treat it as a fast planning estimate. Health departments, venues, and event permits can set minimums that override the formula, so always confirm the local requirement.

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: ROUNDUP