How to calculate MTTR and MTBF in Excel?

You can calculate MTTR and MTBF in Excel by organizing your failure and repair data into a simple table, then using basic formulas: MTTR = total repair time / number of failures, and MTBF = total uptime between failures / number of failures. Both metrics are straightforward to set up in a spreadsheet, even without advanced Excel skills. This article walks through the exact steps, the data you need, and the benchmarks that matter for industrial equipment.

What is the difference between MTTR and MTBF?

MTTR (Mean Time to Repair) measures how long it takes to restore a piece of equipment after a failure. MTBF (Mean Time Between Failures) measures how long equipment runs reliably between failures. MTTR focuses on recovery speed; MTBF focuses on equipment reliability. Together, they give maintenance teams a complete picture of asset health and service performance.

Think of them as two sides of the same coin. A low MTTR tells you your team responds and resolves issues quickly. A high MTBF tells you your equipment fails infrequently. For industrial manufacturers managing complex, high-value assets, both numbers directly affect production output, SLA compliance, and the cost of unplanned downtime.

Here is a quick summary of the key differences:

MTTR measures repair efficiency — how fast your team recovers from a failure
MTBF measures asset reliability — how long equipment runs before the next failure
MTTR is a service performance metric; MTBF is an equipment health metric
Both are calculated per asset or per asset type, not across an entire facility as a single number
Improving MTBF requires better preventive maintenance (PM); improving MTTR requires better dispatch, documentation, and technician readiness

What data do you need to calculate MTTR and MTBF?

To calculate MTTR and MTBF in Excel, you need a log of every failure event for each asset, including the time the failure started, the time repair was completed, and the time the asset returned to normal operation. Without clean, timestamped failure records, neither calculation will be accurate.

Specifically, you need the following data columns for each failure event:

Asset ID — unique identifier for the equipment (e.g., chiller unit, RTU, production line motor)
Failure start timestamp — when the fault was detected or reported
Repair start timestamp — when a technician began active work on the asset
Repair end timestamp — when the asset was confirmed operational again
Total operating time — hours the asset ran between this failure and the previous one

The more consistently this data is captured, the more reliable your MTBF calculations become over time. Many manufacturing teams still log this manually in spreadsheets or paper work orders, which introduces gaps. Digital work order systems that timestamp every stage of a repair automatically produce far cleaner data for these calculations.

How do you calculate MTTR in Excel? (Step-by-step)

To calculate MTTR (Mean Time to Repair) in Excel, subtract the repair start time from the repair end time for each work order to get repair duration, then average those durations across all failures for the asset or period. The formula is: MTTR = SUM(repair durations) / COUNT(failures).

Here is the step-by-step setup:

Set up your columns: Column A = Asset ID, Column B = Failure start, Column C = Repair start, Column D = Repair end
Calculate repair duration: In Column E, enter =D2-C2 and format the column as hours (use Format Cells > Number > Custom > [h]:mm)
Sum total repair time: In an empty cell, enter =SUM(E2:E100) (adjust the range to match your data)
Count failures: In another cell, enter =COUNTA(A2:A100) to count the number of failure events
Calculate MTTR: Divide total repair time by the count: =SUM(E2:E100)/COUNTA(A2:A100)

If you want MTTR per asset, use AVERAGEIF to filter by Asset ID: =AVERAGEIF(A2:A100,"Asset-01",E2:E100). This lets you compare MTTR across individual machines, which is far more useful than a single facility-wide average.

How do you calculate MTBF in Excel? (Step-by-step)

To calculate MTBF (Mean Time Between Failures) in Excel, record the total operating time between each failure event, sum those operating intervals, and divide by the number of failures. The formula is: MTBF = SUM(operating time between failures) / COUNT(failures). Operating time means only the hours the asset was actively running — repair time is excluded.

Here is how to set it up:

Add an operating time column: Column F = hours the asset operated since the previous failure (this is the uptime interval, not the repair time)
Enter operating time manually or calculate it: If you have continuous run logs, use =B3-D2 (next failure start minus previous repair end) to get the uptime interval between failures
Sum all uptime intervals: =SUM(F2:F100)
Count failure events: =COUNTA(A2:A100)
Calculate MTBF: =SUM(F2:F100)/COUNTA(A2:A100)

A common mistake is including repair time in the MTBF calculation. MTBF only counts the time the asset was actually running, not the time it was down for repair. Mixing the two inflates your MTBF figure and makes equipment appear more reliable than it is.

What are good MTTR and MTBF benchmarks for industrial equipment?

For industrial manufacturing equipment, a strong MTTR benchmark is under 4 hours for critical assets. MTBF benchmarks vary significantly by asset type — from hundreds of hours for high-cycle machinery to thousands of hours for process cooling systems and chillers. Industry experience consistently shows that world-class maintenance operations target MTTR under 2 hours for mission-critical equipment.

Some practical reference points for industrial settings:

MTTR under 4 hours is considered acceptable for most production-line equipment; under 2 hours is world-class for critical assets
MTBF above 2,000 hours is a common target for industrial refrigeration and process cooling systems
MTBF above 5,000 hours is achievable for well-maintained chillers and RTUs with consistent PM schedules
First-time fix rate and MTTR are closely linked: teams that arrive with full asset history and the right parts resolve issues faster, directly reducing MTTR

The most useful benchmark is your own historical baseline. Track MTTR and MTBF per asset over rolling 90-day periods, then compare against your previous periods. Improvements in PM scheduling, technician documentation access, and dispatch accuracy all move these numbers in the right direction.

Why inaccurate field data undermines your MTTR and MTBF calculations

Tracking MTTR and MTBF in Excel is a solid starting point, but the data quality that drives accurate calculations depends entirely on how well your field operations are documented. When technicians record repair times on paper or in disconnected systems, timestamps are inconsistent, failure causes go uncaptured, and the numbers you calculate reflect data gaps as much as actual performance.

This is the core operational pain for asset-heavy industrial manufacturers: unplanned downtime is already expensive, and unreliable metrics make it harder to reduce. We built the Gomocha Field Service Platform specifically for industrial operations where MTTR and MTBF are tied directly to production uptime and SLA compliance. Across 177,484 documented work orders, manufacturing service teams using our platform have reduced unplanned downtime by up to 41%. Here is what drives that outcome:

Automatic work order timestamping captures failure start, repair start, and repair completion without manual entry — giving you clean, consistent data for MTTR and MTBF calculations from day one
Offline-capable mobile app ensures technicians on the plant floor, in mechanical rooms, or at remote sites can access full asset history, PM checklists, and safety documentation without needing a signal. This directly supports a 19% improvement in first-time fix rates, which is one of the fastest levers for reducing MTTR
No-code Workflow Designer lets operations teams configure PM checklists per asset type, refrigerant tracking forms, and repair workflows without waiting on IT — so the right data gets captured consistently every time
Native ERP integration with AFAS and Microsoft Dynamics, plus SAP and JDE connectors, means your work order data flows directly into the systems where maintenance managers already track performance
Fast time-to-value — our platform goes live in weeks, not the 12–18 months a ServiceNow or Salesforce Field Service rollout demands, with a documented 3-month rollout for manufacturing customers

If you want to understand where your current field operations are losing time and how that translates into your MTTR and MTBF numbers, start with our Efficiency Assessment. It is the fastest way to identify the specific gaps between where your metrics are today and where they need to be.

Frequently Asked Questions

Can I use the same Excel spreadsheet to track MTTR and MTBF for multiple assets at once?

Yes — the most efficient approach is to build a single master table with an Asset ID column and use Excel’s AVERAGEIF and SUMIF functions to calculate MTTR and MTBF per asset dynamically. You can also add a PivotTable on top of your data to instantly summarize both metrics by asset, asset type, or time period without duplicating your formulas. This way, one spreadsheet scales across your entire equipment list without becoming unmanageable.

How often should we recalculate MTTR and MTBF to make the numbers meaningful?

A rolling 90-day window is the most practical cadence for most industrial maintenance teams — it’s long enough to smooth out one-off anomalies but short enough to reflect recent improvements in your PM program or technician processes. Recalculating monthly against that 90-day window lets you spot trends early. Avoid calculating MTBF over too short a period (fewer than 5–10 failure events per asset), as the averages won’t be statistically reliable.

What's the most common mistake teams make when first setting up MTTR and MTBF tracking in Excel?

The single most common mistake is inconsistent timestamp capture — specifically, teams often record repair end time but forget to log when the failure was first detected or when the technician actually started work, which makes MTTR calculations either inaccurate or impossible to verify. A close second is including downtime (repair time) in the MTBF operating hours, which artificially inflates the reliability figure. Before you build your formulas, standardize exactly what each timestamp means and who is responsible for logging it.

What's the difference between MTTR and MTTF, and do I need to track both?

MTTF (Mean Time to Failure) is used for non-repairable components — it measures how long a part lasts before it fails permanently and must be replaced, such as a bearing or a sensor module. MTTR applies to repairable assets or systems that are restored to service after a failure. For most industrial equipment and production-line assets, MTBF and MTTR are the relevant pair to track; MTTF becomes useful when you’re analyzing component-level replacement cycles or planning spare parts inventory.

How do I handle partial repairs or recurring failures on the same asset within a short time window?

If a repair is incomplete and the asset fails again within a short window (sometimes called a repeat failure or callback), log it as a separate failure event with its own timestamps — do not merge it with the original work order. This is important because masking repeat failures hides a real reliability problem and artificially inflates your MTBF. Tracking repeat failures separately also lets you identify which assets or failure modes are driving your worst MTTR performance, which is where PM and parts stocking improvements will have the greatest impact.

At what point does tracking MTTR and MTBF in Excel become a limitation, and when should we consider dedicated software?

Excel works well as a starting point when you’re managing fewer than 20–30 assets and your team can maintain disciplined, consistent data entry. The limitations become significant when you’re dealing with multiple technicians entering data from the field, assets spread across multiple sites, or when you need real-time visibility rather than periodic manual updates. At that point, the data quality issues — missed timestamps, inconsistent entries, version conflicts — start producing unreliable metrics, and the time spent maintaining the spreadsheet outweighs its value.

Can improving MTTR alone meaningfully reduce our overall unplanned downtime costs?

Yes, significantly — because unplanned downtime cost is largely a function of how long production is halted, not just how often failures occur. Cutting MTTR from 6 hours to 2 hours on a critical asset can reduce the financial impact of each failure event by two-thirds, even if MTBF stays flat. The levers that move MTTR fastest are technician access to asset history at the point of repair, first-time fix rate improvements (arriving with the right parts and documentation), and streamlined dispatch — all of which can be addressed independently of your PM program.