Robert Smith

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating time with text	[email protected]	Excel Worksheet Functions	4	July 29th 05 04:22 AM
Text Wrapping	JMB	Excel Discussion (Misc queries)	0	July 29th 05 02:41 AM
Conversion of a Number into English Text	Nasir Ali	Excel Worksheet Functions	1	July 28th 05 08:50 AM
Changing Text to Time in Excel	Chip193	Excel Discussion (Misc queries)	1	July 27th 05 05:53 PM
Autofitting a row	Josephine	Excel Discussion (Misc queries)	2	March 3rd 05 03:37 PM

All times are GMT +1. The time now is 10:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us