Time Problem

  • Thread starter Thread starter Robert Smith
  • Start date Start date
R

Robert Smith

I have uploaded an ASCII text file to Excel. One of the fields is a 6 digit
field for time. When I get it in the spreadsheet, I can not change it to
time (154503 - should be 15:45:03). I've tried all the time and custom
features but it still won't work or it will give me 00:00:00.
Any ideas what I need to do?

--

---------------------------------------------
Robert (RJ) Smith T.E.M.
Beaumont Police - Sgt.
Beaumont Emergency Management - Assist Coord.
P.O. Box 3827
Beaumont Tx 77701
409-880-3830 (Off) 409-880-3895 (Fax)
www.disaster-research.us
 
Robert Smith said:
I have uploaded an ASCII text file to Excel. One of the fields is a 6 digit
field for time. When I get it in the spreadsheet, I can not change it to
time (154503 - should be 15:45:03). I've tried all the time and custom
features but it still won't work or it will give me 00:00:00.
Any ideas what I need to do?

You could use a formula such as
=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))
 
Back
Top