Ask Your Question
0

Problems with =AVERAGE ...

asked 2016-10-07 02:54:46 +0200

abi gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-10-07 10:02:25 +0200

m.a.riosv gravatar image

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

image description

edit flag offensive delete link more
0

answered 2016-10-08 17:11:58 +0200

abi gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-07 02:54:46 +0200

Seen: 53 times

Last updated: Oct 08 '16