hours into days, hours, and minutes

A

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
 

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

Convert hours into days hours minutes 1
hours converted to Days hours and minutes 1
Hours and sum of hours 2
Convertin hours into days, hours and minutes 6
Changing decimal numbers to hours and minutes 1
convert hours and minutes into days 2
Convert minutes into hours 3
sum hours and minutes with Excel 2000 9

Top