View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Averaging time in hh:mm format

What is your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ryan" wrote in message ups.com...
|I am trying to average 'call handle time' for a week.
|
| 1) I use VLOOKUP to pull the data from a daily report
| 2) I have applied a format of [h]:mm:ss
|
| The cells look like this -- it's throwing a #DIV/0! error. Any ideas?
| D6 E6 F6 G6 H6
| 00:05:10 00:04:17 00:04:50 00:05:21 00:05:10 #DIV/0!
|