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(":", A1, FIND(":", A1, FIND(":",A1,1)+1)+1)
C1 = LEFT(A1,B1-1)
D1 = MID(A1,B1+1,4)
E1 = TIMEVALUE(C1 & "." & TEXT(D1,"000"))

Russell Kent

Paul Lamar replied:

Is that 0.148535347 result in hours, minutes, or seconds?

That is the Excel internal format of a time, which is stated in days.
So 3 hours, 33 minutes, 53.454 seconds is 0.148535347 days.  Multiply by
86,400 to get 12,833.4539808 seconds (darned close to the original
value).

Russell Kent


0.148535347 day ? :) ROFL

This explains a lot. Since we need feet per second per second
we will need to convert the time column to this form of seconds
and subtract that. The beauty of this it will handle
hour roll overs automatically.

Thanks Russell you do good work.

Paul Lamar ...No rotor no motor.

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