Thanks, that works fine for one number conversion. Is there a way for it to
display purely as min.secs (1.45) when the result has been averaged, and
although I have put this into my spreadsheet, and it does work great, I am
struggling with how to combine it with an average,( an average of three
columns A,B,C all entered in the same format and all needing to be converted
to time and then the result showing in col D.

Hope that makes sense.

Sybs


"Miguel Zapico" wrote:

You may transform the decimal entry to minutes and seconds with a formula
like this:
=TIME(0,INT(A1),MOD(A1,1)*100)
This will split the number on the decimal point, and add the integer part to
the minutes and the decimal part to the seconds.

Hope this helps,
Miguel.

"SYBS" wrote:

Hi,

I have a problem with averaging times.

This is what I have

e12 €“ i12 are input as the time taken to achieve a task. This could be
anything from 0.01 (min.secs) up to 9.59. These times are then averaged to
return a value in P12. I am struggled to validate the type of entry to go
into the five time boxes, point 1. I dont seem to be able to validate using
time and if the times are entered as 1.59, 147, etc , point 2, when they are
averaged they average to 100/ths of a second, in other words instead of
recognising as time it treats as a decimal (up to 100 ths instead of 60 ths).
I really am at a loss here. Anyone help please.

Thanks

Sybs