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