Posted to microsoft.public.excel.programming

external usenet poster

Posts: 9

Converting Text Values to Time

I have a spreadsheet that contains general text: 1.05, 2.03, 0.03
This is really time (i.e., 1.05 equals 0:01:05). How do I convert this
general text to time values?

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
Converting values to text	Keith Rathband	New Users to Excel	3	October 4th 08 11:18 PM
Converting date/time serial values to cumulative time totals...	Kevin B	Excel Discussion (Misc queries)	4	October 18th 07 05:05 PM
converting time values	redtool_man	Excel Discussion (Misc queries)	3	January 6th 06 01:51 PM
Converting Text to Values	JEFF	Excel Programming	2	August 3rd 05 03:10 PM
vba is converting text to values!	Bill_S	Excel Programming	2	April 26th 05 03:52 AM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us