aht

Hi All, I am trying to create an excel file that calculates your running average handling time in a call centre function. I'm not sure if the formula I am using is correct though. Hoping for a piece of advice on this. Kind Regards @RhysBillOfficial

Do you know of a way to forecast a monthly service level if you have the monthly volume (all up), AHT and actual FTE that will be staffed?

Hello Everyone, I have been banging my head to figure out this task. <tbody> 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> I have the AHT for the first week by each of the agent. But the...

So in this report I am using I have created a template that is for pasting raw data. then I have a mast sheet that is sorted into columns as the table below. I am trying to write a vba that uses either vlookup like this: =VLOOKUP(B3,Calls!A:C,3,FALSE) for the aht and the column changes based on...

hi! i am once again reaching out for support on coming up with a table with formulas to present for the following: choose from specific range of values to identify specific skill compute for # of those who passed & those who did not compute for bonus 1 (those passed will get 10% of the...