Format serial date and time
Another way
=--TEXT(TEXT(LEFT(A1,8),"0000\-00\-00"),"dd/mm/yyyy")--TEXT(TEXT(RIGHT(A1,4)
,"00\:00"),"hh:mm")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Barb Reinhardt" wrote in message
...
The serial date in EXCEL for the string you gave is 38361.40.
I converted it using the following equation
=DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(MID(A1,7,2 )))+TIME(MID(A1,9,2),MID(A
1,11,2),)
where A1 contained the value 200501090932.
"Cedric" wrote in message
...
I have been trying to format a serial date to the format yyyy/mm/dd 00;00
am
An example of the text is 200501090932. The time is in military time. I
have
tried the text ot columns but my string is too long. Any help will be
greatly
appreciated.
|