How is outbound AHT calculated?

With phone calls, the formula is pretty straightforward: add your total talk time to the hold time and after-call work (ACW) time, then divide it by the number of calls. The result is your AHT for phone support.

Table of Contents

How is call center talk time calculated?

The Average Talk Time Formula Average Talk Time = Total Handling Time – Total Hold Time – Total Wrap-up Time ÷ Number of Calls Handled.

What is AHT in call Centre?

Average handle time, or AHT, is a customer service metric that measures the average length of a customer’s call. It’s a common KPI for contact centers.

What does the average handle time AHT calculation include?

Average handle time includes the entire customer interaction — starting from when the customer call begins to hold time and after-call work is completed. AHT often relates to customer satisfaction and agent performance. In theory, the quicker you resolve a customer’s concern, the happier they will be.

How do I calculate average handling time in Excel?

How to Calculate Average Handling Time in Excel (2 Easy Ways)

Average Handling Time.xlsx.
=Average Handling Time=(Total Talk Time+Total Hold Time+Total After Call Task Time)/Number of Calls.
=SUM(D5:F5)/C5.
=(D5+E5+F5)/C5.

How do I calculate my aht email?

So, we would measure AHT by adding up the total time it took to resolve each case, starting from when it was first opened. For example, my business received 500 email tickets and took 10K minutes to resolve them all. In this case, AHT would be 20 minutes per email (10,000 minutes / 500 emails = 20 minutes).

How do you find the percentage of AHT?

To calculate average handle time, add total talk time with total hold time, then add ACW. Lastly, divide that by the total number of calls to get the AHT. AHT can be assessed per agent, per department, or across the organization.

How do you calculate production AHT?

So, here’s what your equation looks like for figuring AHT: Talk time + Hold time + After-call time / Number of Calls = AHT….His totals for the day looked like this:

Talk time: 15 minutes total.
Hold time: 5 minutes total.
After-call time: 7 minutes total.

How do you calculate AHT in a pivot table?

Follow these steps:

Click the down arrow next to the word PivotTable at the left side of the PivotTable toolbar.
Choose Formulas | Calculated Fields.
In the Name box, enter a name for your new field.
In the Formula box, enter the formula you want used for your weighted average, such as =WeightedValue/Weight.
Click OK.

How is chat process AHT calculated?

To calculate AHT for a phone channel, divide the sum of your total talk, hold, and follow-up time by your total number of calls. Follow-up time includes the time it takes to get back to a customer if the case isn’t resolved on the initial call or chat.

How do you calculate call handling capacity?

Step 1: Work Out How Many Calls Are Coming Into the Business.
Step 2: Work Out the Number of Calls for Every 30 Minutes/Hour.
Step 3: Work Out Your Average Handling Time.
Step 4: Determine Your Service Level.
Step 5: Factor in Maximum Occupancy.
Step 6: Calculate Your Shrinkage.
Step 7: Work Out Your Average Patience.

How do you average AHT in Excel?

To find the average handling time of an employee, we need to sum up total talk time, total hold time and total after call task time. Then, divide it by the number of calls. After Call Task is sometimes expressed as ACT in short form.

How is call center utilization rate calculated?

Simply take the amount of time your agents are reported as being on calls or performing call-related tasks and divide it by the total time they are on the clock. Multiply the resulting number by 100, and you have the agent utilization percentage.

How do you calculate FTE volume and AHT?

First answer: 100(calls)*180(aht)/3600 (hour) I get 5, not 10 calls per hours. The result should be giving 5 FTE needed. But you are saying “100 calls arrive in 30 minutes”,then you should divide 1800 instead of 3600 then you will get answer of 10 FTE required. I assume you have used 80% occupancy in your formula.

How do you calculate workload in a call center?

Call Center Agents Workload Formula: It’s the same for the call center agents as the number of agents needed for a call center= (Number of Accounts * Frequency of inbound and outbound calls * Length of a call) / time available for one call center agent.

What is the formula for average time?

After subtracting the total exits from the page views, divide the total time by the product of the subtraction to receive your average time.

How do you calculate AHT in Excel?

To calculate AHT, add your total talk time + total hold time + total after-call tasks, and then divide by the number of total calls.