A1 = 1:30.4 (m:s.0)

=TIME(,,INT(A1*86400))+ROUND((A1-TIME(,,INT(A1*86400)))/2,7)

Format as m:s.0 or mm:ss.0

Note that you won't get an exact correlation due to rounding:

10th...........5th
0.0............0.0
0.1............0.1
0.2............0.1
0.3............0.1
0.4............0.2
0.5............0.3
0.6............0.3
0.7............0.4
0.8............0.4
0.9............0.4

See this screencap for a comparison with Herbert's method:

http://img299.imageshack.us/img299/7795/10sto5skl6.jpg

--
Biff
Microsoft Excel MVP


"M.A.Tyler" <Great Lakes State wrote in message
...
I need to measure time in fifths of a second, example 1:30.4 read one
minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler