Service level formula in Excel or Google Sheets
Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.
| Cell | What | Value or formula | Example |
|---|---|---|---|
| B2 | Contacts offered | 4000 | 4000 |
| B3 | Answered within the threshold | 3150 | 3150 |
| B4 | Abandoned before the threshold | 120 | 120 |
| B6 | Service level (%) | =ROUND(B3/(B2-B4)*100,1) | 81.2 |
Get the ready-made spreadsheet
The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).
Go further with the ebook
Head of Support
The blueprint to build, staff and lead a 50-agent support department, with the dashboards I used.
$39.99 · 233 pages · View the book
Frequently asked questions
- How do you calculate service level?
- Divide the contacts answered within your threshold (for example 20 seconds) by the contacts offered, minus those abandoned before the threshold. 3,150 ÷ (4,000 − 120) is 81.2%.
- What does 80/20 mean?
- 80% of contacts answered within 20 seconds. It is a classic voice target; chat teams often use 80% within 60 seconds, and email is measured as a response time instead.
- Should short abandons be excluded?
- Excluding callers who hang up within a few seconds is common, but write the rule down and keep it. Different rules make service levels impossible to compare between teams.
- How do you calculate service level in Excel?
- Put contacts offered in B2, answered within the threshold in B3 and abandoned before the threshold in B4, then use =ROUND(B3/(B2-B4)*100,1). With 4,000, 3,150 and 120 that gives 81.2%. The free Excel template below has it set up.
About the author
Abdessamad Ghanem
Customer Experience & Customer Success Consultant · Founder of Clarivoxx
Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.