Divide the number by 24 and format the cell as time. If you want to do it
all in the same cell, enter 24 an unused cell, copy it and then Paste
Special Divide into the cell(s) with the numbers.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"B. Baumgartner"
wrote in
message news:B.Baumgartner.1rih2b_1120255503.9601@excelfor um-nospam.com...

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