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
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
- Paste incident records as CSV:
created, resolvedrequired;incident, acknowledged, priorityoptional. - Enter targets as
priority;ack min;resolve minone per line (optional). - 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
| Input | Value |
|---|---|
| Incident records (CSV) | |
| Targets | |
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
| Input | Value |
|---|---|
| Incident records (CSV) | |
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
- SLA Downtime and Availability CalculatorShows how much downtime an SLA percentage really allows and whether current downtime exceeds the budget.
- Security Incident Timeline BuilderMerges EDR, firewall, SIEM and team notes into one sorted, time-zone-corrected timeline.
Related service: Technical Support and Scheduled Maintenance