hours converted to Days hours and minutes
 

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

hours converted to Days hours and minutes
 

Am I correct that you are not using the Excel date/time
values (where 1.0 would equal one day) but instead a
decimal number for the hours value? If that is true, then
this formula will convert the number into
days/hours/minutes (assuming your hours value is in cell
A1):

=INT(A1/24)&" days "&INT(MOD(A1,24))&" hours "&ROUND(MOD
(A1,1)*60,0)&" minutes"

-----Original Message-----
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
.