Hi!

Try this:

Enter this formula using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF(A2:A60,A2:A6))

Format the cell as h:mm:ss

Biff

"Jan G. Thorstensen" wrote in message
...
Hi.
I try to figure out the average time spent in a range but cant figure out
how.

This is how it looks like:

00:00:10
00:00:06
00:00:00
00:00:04
00:00:04
------------
=AVERAGE(A2:A6)
===============
Here is a total of 24 seconds.
These seconds should be divided with 4 and return the answer; 00:00:06.

The problem is:
1) One row does not contain any hours, minutes or seconds and should not
be counted.
2) Even when there is no figures in that particular row, the answer
returned is wrong?

Anybody have a suggestion?

Thanks in advance for your help!

Jan