| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Another formula that will convert it:
=--TEXT(A1,"00\:00\:00") Still format as time. Robert Smith wrote: 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 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating time with text | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Conversion of a Number into English Text | Excel Worksheet Functions | |||
| Changing Text to Time in Excel | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
Threaded Mode
