IT Operations, Risk and Audit · #99

Online MTTA and MTTR Calculator

Measures response and resolution times per priority from support records and counts target breaches.

  • Data is processed in your browser and not sent to a server
  • Export: CSV

Tool

Time YYYY-MM-DD HH:MM or DD.MM.YYYY HH:MM.

priority;ack min;resolve min

What does this tool do?

MTTA (mean time to acknowledge) and MTTR (mean time to resolve) are the core metrics of support performance and SLA compliance. The mean alone can mislead: one long incident inflates it. The tool gives the median along with the mean and compares with targets per priority.

How to use it

  1. Paste incident records as CSV: created, resolved required; incident, acknowledged, priority optional.
  2. Enter targets as priority;ack min;resolve min one per line (optional).
  3. Press Run; download the table as CSV.

Fields

Incident records (CSV)
Time YYYY-MM-DD HH:MM or DD.MM.YYYY HH:MM.
Targets
priority;ack min;resolve min

Worked example

InputValue
Incident records (CSV)
incident,created,acknowledged,resolved,priority
INC-1,2026-11-01 09:00,2026-11-01 09:10,2026-11-01 11:00,P1
INC-2,2026-11-02 14:00,2026-11-02 14:40,2026-11-03 10:00,P2
INC-3,2026-11-05 08:00,2026-11-05 08:05,2026-11-05 09:30,P1
INC-4,2026-11-06 16:00,2026-11-06 16:20,,P3
Targets
P1;15;240
P2;30;480
P3;60;1440

Expected result: MTTA 18 min 45 s, MTTR 7 h 50 min (median 2 h). The P2 record breached both the response (40 min > 30) and resolution (20 h > 8 h) targets; 1 record is still open.

A single P2 record pushes the MTTR mean up; the median (2 hours) shows the typical case better. Report both and handle breaching records with root cause analysis.

Second scenario

InputValue
Incident records (CSV)
id;created;resolved
T-1;01.11.2026 08:00;01.11.2026 12:00
T-2;02.11.2026 08:00;02.11.2026 09:00

Expected result: Two records with only open and resolve times: MTTR 2 h 30 min; MTTA is not calculated as there is no acknowledge time.

Method and assumptions

Response time = acknowledged − created; resolution time = resolved − created (calendar time, 24/7). MTTA/MTTR are arithmetic means, the median is the middle value. Records without resolve time are open and excluded from MTTR.

Using the result and troubleshooting

Report MTTA/MTTR and breach counts per priority in the monthly service report; use the SLA tool for availability and the Incident Timeline tool for post-incident review.

Limits and common mistakes

  • Business-hour calendars, pending states and reopened records are not considered; all times are assumed to be in one time zone.

Frequently asked questions

What does the R in MTTR stand for?

Depending on the source: repair, recovery, resolve or respond. Here it is the time from opening to resolution; state the definition in your reports.

Related tools and service

Related service: Technical Support and Scheduled Maintenance

Systems online tools · See all online tools