Calculate future AHT ( Average Handling Time )

[roy00a4]

Hello Everyone,

I have been banging my head to figure out this task.

Name	Wk 1 AHT	Wk 2 AHT	Wk 3 AHT	Wk 4 AHT	Target
A	0:19:18				0:17:00
B	0:20:17				0:17:00
C	0:13:38				0:17:00
D	0:15:31				0:17:00

<tbody>
</tbody>

I have the AHT for the first week by each of the agent. But the MTD target is 17 mins. What is the weekly AHT they need to maintain to meet the MTD target?

I need a formula to figure this out. I cant think of anything that woukld work. Please help !!

 

[Eric W]

Perhaps:

	A	B	C	D	E	F	G
1	Name	Wk 1 AHT	Wk 2 AHT	Wk 3 AHT	Wk 4 AHT	Target	average needed to make target
2	A	0:19:18	0:21:21	0:14:23	0:11:58	0:17:00	Made target!
3	B	0:20:17	0:14:24	0:16:52	0:16:35	0:17:00	Missed target
4	C	0:13:38	0:15:43			0:17:00	0:19:20
5	D	0:15:31				0:17:00	0:17:30
6							0:00:00
7

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula G2 =IF(COUNT(B2:E2)=4,IF(SUM(B2:E2)/4< F2,"Made target!","Missed target"),(F2*4-SUM(B2:E2))/(4-COUNT(B2:E2))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[roy00a4]

Hi Eric,

Thank you so much for the fast response and help. Amazing.

Cheers,
Roy

 

[Eric W]

Glad to help!