I need help with averaging times that also contain fifths of a second. I have a column of times in DP from row 194 thru 358. Every row in column DQ contains the average for that same row in DP and up to the top (DP194).
This is an example from row 199 of the formula that I have on each row in DQ: =AVERAGE($DP$194:$DP199).
The times are formatted as m:ss.f (minutes : seconds . fifths of a second (base 5)). The problem is that this formula does not take into account that those are fifths of a second to the right of the decimal point, instead of a decimal. Is this possible to do this?
The possible values to the right of the decimal point are: 0, 1, 2, 3, 4 .
Examples of the times in DP that need to be averaged: 1:42.0 , 1:59.4 , 2:02.1
I'm using Office XP.
Thank you for any help.
SteveC
This is an example from row 199 of the formula that I have on each row in DQ: =AVERAGE($DP$194:$DP199).
The times are formatted as m:ss.f (minutes : seconds . fifths of a second (base 5)). The problem is that this formula does not take into account that those are fifths of a second to the right of the decimal point, instead of a decimal. Is this possible to do this?
The possible values to the right of the decimal point are: 0, 1, 2, 3, 4 .
Examples of the times in DP that need to be averaged: 1:42.0 , 1:59.4 , 2:02.1
I'm using Office XP.
Thank you for any help.
SteveC