Forum Discussion
Formula understanding
Hi, I need help understanding the following formula : =(SUMIFS('Agent Vol'!G:G,'Agent Vol'!A:A,"="&W4,'Agent Vol'!E:E,"=ACD"))/B4 I need to understand how the avg.talk time is calculated fro...
Greetings!
Have tried with data inputs in the attached sheet, converted the time into minutes, divided it by number of answered calls i.e. 98 the average talk time comes to 08:81 .
May pls see.
Thanks,