hours converted to 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
 
K

K Dales

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"
 

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

hours into days, hours, and minutes 1
Convert hours into days hours minutes 1
Convert Hours and Minutes 5
hours / minutes 3
Convert Decimal Minutes to Hours-Minutes-Seconds 3
Another Days, Hours, Minutes, Question 6
Changing hour and minutes to percentage of hours 1
Sum work hours to hours & nearest 10th of an hour 14

Top