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
(as text)
3:33:53:454    8        3:33:53    454        0.148530613
3:33:53.045

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,"0000"))
F1 = E1

Russell Kent


Nice.
Jay Horak


The Rotary Engine NewsLetter. Powered by Linux.
ACRE NL web site. http://www.rotaryeng.net
Copyright 1998-2005 All world wide rights reserved.