| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to calculate average call length
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Average Length of Service | Excel Worksheet Functions | |||
| Calculate average of ratings as a function of length | Excel Worksheet Functions | |||
| Calculate call cost in seconds | Excel Worksheet Functions | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| Call list length in formula | Excel Discussion (Misc queries) | |||
Threaded Mode
