Hey Guys,
I am trying to get a solution that will average a list of times not including the time "00:00"
Here is what I have at the moment which is not working:
A1=0:00
C10=12:51
=AVERAGE(IF(A1<>TIMEVALUE("00:00"),A1,""),IF(C10<>TIMEVALUE("00:00"),C10,""))
I also tried:
=AVERAGE(IF(A1<>TIMEVALUE("00:00"),A1,0),IF(C10<>TIMEVALUE("00:00"),C10,0))
Which evaluates to = 6:25 ie. (0+12:51/2)= 6:25
I also require "AVERAGE" rather than SUM/COUNT as this will need to evaluate the average of a lot of cells that aren't in a list (A1,A2,A3) but are over many sheets and different locations....this will get very messy with SUM/COUNT solutions.
Any help would be great.....im sure it is a simple solution...I just can't find it!!!
Thanks

I am trying to get a solution that will average a list of times not including the time "00:00"
Here is what I have at the moment which is not working:
A1=0:00
C10=12:51
=AVERAGE(IF(A1<>TIMEVALUE("00:00"),A1,""),IF(C10<>TIMEVALUE("00:00"),C10,""))
I also tried:
=AVERAGE(IF(A1<>TIMEVALUE("00:00"),A1,0),IF(C10<>TIMEVALUE("00:00"),C10,0))
Which evaluates to = 6:25 ie. (0+12:51/2)= 6:25
I also require "AVERAGE" rather than SUM/COUNT as this will need to evaluate the average of a lot of cells that aren't in a list (A1,A2,A3) but are over many sheets and different locations....this will get very messy with SUM/COUNT solutions.
Any help would be great.....im sure it is a simple solution...I just can't find it!!!
Thanks
