Forum Discussion
pq23or
Apr 08, 2021Copper Contributor
time average in excel??
hi, im trying to average times in format hh:mm, for example 22:00 21:30 03:00 00:00 so i get average between the smallest and latest value? any help thanks
pq23or
Apr 08, 2021Copper Contributor
hi, well in the example 22:00PM would be smallest value and largest would be 3:00AM
MindreVetande
Apr 08, 2021Iron Contributor
Ok, 22:00 is the first time so it might be the lowest. But if it's in a chronologically order 00:00 comes after 03:00 so it should be the last.
I simply don't get the pattern. Is 00:00 an empty value that you want to exclude?
This takes the mean from the first cell in column A and the last cell with a value that is not 0
=mean(A1,INDEX(A:A,MAX(Row(A:A)*(A:A<>0))))