Estimate Crew Hours for a Move from Volume

Excel Formulas › Moving & Storage

All versions

To schedule a move you need hours on site, not just total labor. Convert volume to man-hours with a productivity factor, then divide by crew size to see how long the job actually takes.


Quick formula: Man-hours divided by the number of movers:
=B2*B3/B4

The productivity factor (man-hours per cubic foot) comes from your own job history.

Functions used (tap for the full reference guide):

The example

800 cubic feet at 0.025 man-hours per cubic foot, with a 3-person crew.

AB
1LabelValue
2Cubic feet800
3Man-hours per cu ft0.025
4Total man-hours20
5Crew size3
6Hours on site6.7

The formula

First man-hours, then hours on site:

=B2*B3 // 800 * 0.025 = 20 man-hours

How it works

Working it through:

  1. Estimate volume in cubic feet from your survey (B2).
  2. Multiply by your productivity factor in man-hours per cubic foot (B3): 800 × 0.025 = 20 man-hours.
  3. Divide total man-hours by the crew size (B5) to get hours on site.
  4. 20 ÷ 3 ≈ 6.7 hours for a three-person crew.

Add drive time and a setup buffer, then bill the crew hours at your hourly rate.

Try it: interactive demo

Interactive

Enter volume, productivity, and crew size — see hours on site.

Variations

Round up to billable hours

Round on-site hours up to the next half hour for billing.

=CEILING(B2*B3/B5,0.5)

Add drive time

Include a fixed travel allowance in the scheduled time.

=B2*B3/B5+1

Pitfalls & errors

Your productivity factor must match your crews and conditions. Stairs, long carries, and elevators all slow the job — calibrate from real timesheets.

Estimate man-hours first, then divide by crew size. A bigger crew shortens on-site time but doesn't change total man-hours much.

Practice workbook

📊
Download the free Estimate Crew Hours for a Move from Volume practice workbook
Change the yellow volume, factor, and crew size; man-hours and on-site hours recalculate.

Frequently asked questions

Where does the productivity factor come from?
From your own timesheets — total man-hours divided by cubic feet across past jobs. Start near 0.02–0.03 and refine with your data.
Does a bigger crew finish faster?
On-site hours drop because man-hours are shared, but total man-hours (and labor cost) stay roughly the same.
What about stairs and long carries?
They raise the man-hours per cubic foot. Keep separate factors for easy, moderate, and difficult access if you can.

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: Estimate weight from cubic feet · Overtime pay calculation

Function references: ROUNDCEILING