Convert floating point to Hours and Minutes ??

[sygibson]

Hello all - I would like to convert a floating point number (eg 3.25)
to Hours and Minutes (eg 3:15). I've been poking and prodding at this
for quite a long time, and can't find a solution. Does anyone have a
fast and dirty trick for doing this?

Essentially, I have a spreadsheet that does a bunch of time
calculations based on speed and distance. Once I've done that, I'd
like to convert the finished notation into a time value.

I'm using Excel 2002. Thank you any and all for your insights or help.

 

[Biff]

Hi!

To do it in place:

Enter 24 in an empty unformatted cell.
Goto the menu Edit>Copy
Select the cells to convert
Then, Edit>Paste Special>Divide>OK
Format the cells as [h]:mm
Delete the 24 from the cell

Using a formula and another column of cells:

A1 = 3.25

B1 = =A1/24

Format the cells as [h]:mm

Biff