Trying to calculate average call length
Hi
I copied your data into a sheet and applied =Average(A1:A4) and got
00:03:14 as a result
There must be something different about the data you posted compared
with what is in your main sheet.
--
Regards
Roger Govier
pilates_jocelyn wrote:
Usually our phone system spits out a report for me, but it's broken right
now... and I have to provide this info to another department ASAP.
I'm trying to calculate the average call length for our call center agents.
My spreadsheet looks like this:
Call Duration
00:04:39
00:00:58
00:03:18
00:04:02
The cells are custom formatted as hh:mm:ss. All I want to know is the
average length for those four calls. But when I try the AVERAGE function, I
get a DIV/0 error. Any ideas on what I'm doing wrong? Thanks in advance!
|