Pressure Washing: Water Usage in Gallons

Excel Formulas › Pressure Washing

All versions

Your machine's GPM rating times the time on the trigger tells you the gallons a job drinks — the number that sizes your buffer tank and answers "can I use your spigot?"


Quick formula: Machine GPM times hours, times 60 minutes:
=B2*C2*60

A 4 GPM machine running 2.5 hours uses about 600 gallons — more than a 275-gallon tote, so plan the water source.

Functions used (tap for the full reference guide):

The example

Three jobs, each with the machine's GPM and hours of trigger time.

ABCD
1JobGPMHoursGallons
2House wash42.5600
3Driveway41240
4Fleet lot5.541,320

The formula

Three factors, one multiplication:

=B2*C2*60 // gallons/min x hours x 60 min

How it works

GPM is per minute, so hours need the ×60:

  1. B2 is the machine's rated gallons per minute.
  2. C2 is hours of actual spraying time, not total time on site.
  3. *60 converts hours to minutes so the units line up: gallons/min × minutes = gallons.

Trigger time is usually 60–80% of on-site time — you are not spraying while moving hoses.

Try it: interactive demo

Interactive

Enter your machine's GPM and the spraying hours.

Variations

Will the tank last?

Divide your buffer tank size by GPM for minutes of runtime.

=TankGallons/B2

Cost of the water

Multiply gallons by your water cost per gallon.

=B2*C2*60*CostPerGal

Pitfalls & errors

Use trigger hours, not hours on site — billing 8 site hours as spray time triples the real water number.

A 275-gallon tote at 4 GPM buys you about 68 minutes of continuous spraying — know your runway before the driveway is half done.

Practice workbook

📊
Download the free Pressure Washing: Water Usage in Gallons practice workbook
Edit the yellow GPM and Hours cells; the Gallons column recalculates.

Frequently asked questions

Is rated GPM what the machine really flows?
Close, but nozzle size and pressure change it. For tank planning, the rating is accurate enough; for exact numbers, time how long it takes to fill a 5-gallon bucket.
How do I size a buffer tank?
Multiply GPM by the longest continuous spray stretch in minutes, then add a margin. A 4 GPM machine and 60-minute stretches point to a 275-gallon tote.

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

Related formulas: Pressure Washing: Job Time Estimate · Flow Rate GPM · Pool Volume in Gallons

Function references: PRODUCT