Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul

Divide the value by 24 and format as time.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Paul" wrote in message
...
Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into
hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul

On Tue, 5 Dec 2006 04:08:00 -0800, Paul wrote:

Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul

Excel stores time in "days".

So for fractions of an hour, divide by 24 and format as time.

Be aware that, in order to display more than 24 hours, you must place your hour
token within brackets: [hh]:mm


--ron