Problems with =AVERAGE

[abi]

01:00 02:00 03:00 00:00 00:00 [Frmt Time] =AVERAGE(H1:L1) = 01:23 …

WHY NOT 02:00?

Thank you! gripWIN@gmail.com

[mariosv]

Because zeroes are part of the average. You can use AVERAGEIF() to avoid them.

[abi]

Thank you, for responding.
My result; 0:21 [Frmt>HRS, 13:27