KPI calculator

Average Resolution Time Calculator

Enter your values to calculate Average Resolution Time. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Average Resolution Time books Books that help you understand Average Resolution Time and related business metrics more deeply. Explore resources → Average Resolution Time audiobooks Audiobook searches for learning Average Resolution Time while commuting, walking, or working. Explore resources → Customer success resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Customer experience analytics Practical resources for turning Average Resolution Time into reports, dashboards, and business decisions. Explore resources →

Calculate Average Resolution Time

Total Resolution Time Resolved Tickets

Result—

Formula

Total Resolution Time / Number of Resolved Tickets

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Average Resolution Time =
DIVIDE(
    [Total Resolution Time],
    [Resolved Tickets]
)

Read the complete Average Resolution Time formula guide →