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