Andrew

Posts: n/a

How do I convert time format to text?

I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3

Thanks....Andrew

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
convert number to text and format it.	Goda	Excel Worksheet Functions	2	February 7th 05 08:07 PM
convert number to text and format it.	Goda	Excel Worksheet Functions	2	February 7th 05 04:37 PM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM
Help Q: Entering 7 p time format, does not convert to 19:00	Frank Kabel	Excel Discussion (Misc queries)	0	December 7th 04 07:20 AM
Convert text file to MS_Excel	Aqua Flow	Excel Discussion (Misc queries)	1	November 30th 04 02:55 AM

All times are GMT +1. The time now is 02:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us