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