View Single Post
  #1   Report Post  
Robert Smith
 
Posts: n/a
Default Text to time conversion

I have a text file that I want to import into excel. I have a column that is
a time field. (Ex. 142200)(hh:mm:ss). When I import it and format it in time,
I always get 00:00:00. Is there a command that I need to convert it.
Robert