Robert,

Try

=A2/24/60/60

and format as time


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Robert Smith" wrote in message
...
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