Convert hours into days hours minutes

[Alex]

Is there a function or a code I can create in Excel where
I can create hours into days with hours and minutes. For
example I have 10.66 as hours..I want to change that in
another cell to read 10 hours and whatever minutes .66
resepresents I think its like 37 minutes or so.. the same
if I had lie 28.5 hours..want it to read 2 days 4 hours
and 30 minutes. Thanks

 

[Paulw2k]

Hi Alex

Excel stores dates and times as a number representing the number of days
since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd.tttttt
.. This is called a serial date-time.
http://www.cpearson.com/excel/datetime.htm

So simply convert your hours cells into fractions of a day. If 10.66 is in
A1 (the hours-cell), then in B1 (the days-cell) put the formula =A1/24.
Then format the days-cell with the custom format "dd:hh:mm". It will then
display it the way you want.

0.66 (2/3) of an hour = 40 mins. Excel will probably display this as 39
mins as 0.66 is not quite 2/3. To 4-decimal places, 0.6666, will
take it up to 40.


Regards

Paul