Formating a timestamp as a date and time.

D

Dan

I have imported some data into excell and it is currently looks like this
2006-09-26-11.16.38.902000 I am trying to compare ir get the difference
between two of these timestamps but excell doesn't receognize this format.
What is the easiest way to make this timestamp work? I am using excel 2000.
 
B

Bob Phillips

Transform it

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
W

William Horton

What does this represent?

I am guessing it is Sep 26th 2006 at 11:16:38. What does the .902000 refer
to?

If you import it as 2006-09-26 11:16:38 Excel recognizes it.
(put space between day and hour and put colon instead of period between
hour, minute and second.

Hope this helps.
 
Top