Incorrect time average

kbark

New Member
Joined
Oct 5, 2006
Messages
4
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
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,330
Members
409,863
Latest member
stacy09
Top