Paul,
Disregard my last.  This one is correct.

Unfortunately I think that time format was deliberately chosen
by the SAE in collusion with the EPA.

Is that correct Jay Horak?

I could write a DOS QUICK BASIC program to convert
minutes:seconds:thousands-of-seconds to minutes.xxxxxxxx
Not sure of the number of x's I would get :)

> Paul Lamar


Don't be daft. Excel will let you use text manipulation to get the
correct value.  See attached spreadsheet.

Original    3rd colon    HH:MM:SS    1,000ths    Revised
3:33:53:454    8        3:33:53    454        0.148535347

A1 = "3:33:53:454"
B1 = FIND(":", A2, FIND(":", A2, FIND(":",A2,1)+1)+1)
C1 = LEFT(A2,B2-1)
D1 = MID(A2,B2+1,4)
E1 = TIMEVALUE(C2 & "." & TEXT(D2,"000"))

Russell Kent

Too late :)