I’m having a problem averaging a column of times. I believe my formula is correct
=AVERAGE(E:E)
However, the output/average I’m getting is averaging all of column E and I need it average only the inputted values.
Example:
Column E Values:
35:30
21:50
05:25
00:00
00:00
00:00
I don’t want my formula to consider the 00:00 entries
Thank You ~ Keith
=AVERAGE(E:E)
However, the output/average I’m getting is averaging all of column E and I need it average only the inputted values.
Example:
Column E Values:
35:30
21:50
05:25
00:00
00:00
00:00
I don’t want my formula to consider the 00:00 entries
Thank You ~ Keith