Why doesn't the search function on these forums ever return anything to
me.. sheesh.

Anyway, I have a column of times, in this column there are blank cells
(will have a formula embedded in the cell but no results showing). I
need to find the average time. It works until I hit a bank cell, then
the average goes wacky!

The cell formats are h:mm;; I have also tried 0:00;;

I am using =average(W3:W4000) At the moment I have a value of -222.54
this value should never be a negative number. The values in the cells
are all positive time frame (ie. 0:15 (15 minutes), 3:15 (3 hrs and 15
mins). For that matter I can't seem to get a total time from that
column either, it too ends up wierd. The format of the cell (although I
have tried many) the results end up in is hh:mm (at the moment I have
tried h:mm etc.).

Thanks
Brian


--
Gadgets
------------------------------------------------------------------------
Gadgets's Profile: http://www.excelforum.com/member.php...o&userid=36784
View this thread: http://www.excelforum.com/showthread...hreadid=566175