B. Baumgartner

Posts: n/a

Converting whole number to TIME

I have a whole number, like 11.5 and I want to convert it to 11:30, how
do I do that. (i'd rather it not be in military time).

--
B. Baumgartner
------------------------------------------------------------------------
B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107
View this thread: http://www.excelforum.com/showthread...hreadid=384011

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 time format?	JLHORMAN	Excel Discussion (Misc queries)	1	May 26th 05 06:38 PM
Converting Text to Number	Andrew Bartholomew	Excel Discussion (Misc queries)	1	March 25th 05 02:50 AM
Time Sheets	Lady Layla	Excel Discussion (Misc queries)	1	March 23rd 05 03:22 PM
How do you enter a negative time number in Excel?	Thomas99	Excel Discussion (Misc queries)	4	March 17th 05 11:42 PM
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM

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

About Us

"It's about Microsoft Excel"