Posted to microsoft.public.excel.misc

Ryan[_2_]

external usenet poster

Posts: 7

Averaging time in hh:mm format

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging Time	PeterM	Excel Discussion (Misc queries)	4	January 29th 07 02:16 PM
Averaging Time withing Excel	Fred Smith	Excel Worksheet Functions	2	July 22nd 06 08:08 AM
Averaging Time Difference	vldavis809	Excel Discussion (Misc queries)	1	July 8th 06 09:42 AM
Need help with averaging a time but dates are messing up the result I am trying for.	chadsxe	Excel Worksheet Functions	6	June 15th 06 06:39 PM
Averaging time	katgolightly	Excel Worksheet Functions	5	December 28th 04 10:02 PM

All times are GMT +1. The time now is 05:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us