With the number in A1, use a helper cell:
=a1/24
format it as time.

Ps. 11.5 is not a whole number <vbg.

=====
If you have a whole bunch of cells to do,
Put 24 in an empty cell.
Copy it
select the range to convert
edit|paste special|check divide
format that selection as time.



"B. Baumgartner" wrote:

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

--

Dave Peterson