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
(e-mail address removed)
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number to time conversion 3
Decimal/Percentage to Whole Number 4
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE 3
day of the week and date formula 2
Filter cells with non-whole numbers or comment 4
convert time format 2
Convert Time 3
HOW DO I COMBINE two spreadsheets into one by names in column a 3

Top