Averaging several Durations?

T

Terry Pinnell

I have 3 columns of data, with an AVERAGE() formula at the bottom of
each. But I entered the Duration column in the form HH:MM, and that
seems to be unacceptable:

Dur'n Miles Speed
3:44 6.0 1.6
4:30 9.0 2.0

Averages 0.2 7.5 1.8

Could someone remind me how to alter the function to get a correct
result of 4:07 instead of 0.2 please?
 
N

Niek Otten

Format the average the same way you formatted the inputs and it will show
the expected value
 
Top