MTTR & MTBF in Excel: Formulas, Templates & Reliability Guide
Understanding MTBF vs MTTR in Manufacturing
While OEE measures overall shift performance, MTBF (Mean Time Between Failures) and MTTR (Mean Time to Repair) reveal the health and maintainability of individual assets:
MTBF (Mean Time Between Failures)
The average operating hours a machine runs between breakdown events. Higher is better.
MTTR (Mean Time to Repair)
The average time it takes the maintenance team to diagnose and repair a breakdown. Lower is better.
⚡ Interactive MTTR & MTBF Reliability Simulator
Input your machine operating hours, number of unplanned breakdowns, and total repair hours to instantly compute reliability metrics.
38.4 hrs/failure
1.63 hrs/repair
95.9%
How to Calculate MTTR and MTBF in Excel
In Excel, you can calculate MTTR and MTBF automatically using standard aggregation functions over your maintenance logs:
- MTTR Formula:
=SUM(Downtime_Minutes_Range) / COUNT(Failure_ID_Range) - MTBF Formula:
=(Total_Operating_Minutes - SUM(Downtime_Minutes_Range)) / COUNT(Failure_ID_Range)
Get Automated Reliability Analytics in Excel with Lean Ops Pro
Instead of maintaining manual calculation formulas, Lean Operations Monitor (Lean Ops Pro) automatically computes MTTR, MTBF, PM adherence, and OEE loss breakdowns from your shift logs directly inside your Excel sheet.
Automate MTTR & MTBF analytics in Excel
Install Lean Operations Monitor free from Microsoft AppSource to monitor operations and reliability in your sheets.