Labor efficiency compares the standard (allowed) hours for the work done to the actual hours taken — over 100% means the crew beat standard. It’s the core productivity measure on a shop floor.
The example
520 earned vs 480 actual.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Earned hrs | 520 |
| 3 | Actual hrs | 480 → 108% |
The formula
The formula:
How it works
How it works:
- Earned (standard) hours = units produced × standard hours per unit — the allowed time for the work.
- Divide by actual hours worked for the efficiency ratio.
- Over 100% means the crew produced faster than standard; under means slower.
- Combine with utilization (worked ÷ available) for productivity = efficiency × utilization.
Efficiency and utilization are different levers. Efficiency asks “how fast vs standard when working?”; utilization asks “how much of paid time was spent working?” A crew can be 110% efficient but only 70% utilized (lots of idle/setup), so true productivity — efficiency × utilization — is 77%. Track both to know whether to fix pace or fix scheduling.
Try it: interactive demo
Earned (standard) and actual hours.
Variations
Earned hours
Standard allowed:
Utilization
Worked vs available:
True productivity
Efficiency × utilization:
Pitfalls & errors
Earned, not target. Earned hours come from output × standard time, not a quota.
Efficiency ≠ productivity. Multiply by utilization for the full picture.
Realistic standards. A loose standard inflates efficiency — keep standards current.
Practice workbook
Frequently asked questions
How do I calculate labor efficiency in Excel?
What are earned hours?
What's the difference from utilization?
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