Converting whole number to TIME

B

B. Baumgartner

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).
 
N

Niek Otten

Divide by 24 and format as time

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"B. Baumgartner"
 
S

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
"B. Baumgartner"
 
D

Dave Peterson

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.
 
Top