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!
|
|