How to convert hours in days?

T

Tony

Guys.... how can I make cell A1 (which as 159.25 hours)say 6 hours and so
many mintues?

Thanks for you help

Tony
 
B

Bob Phillips

Tony,

I assume that you mean 6 days etc?

=A1/24

and format as d\d hh:mm:ss

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

joeu2004

Tony said:
Guys.... how can I make cell A1 (which as 159.25 hours)
say 6 hours and so many mintues?
Click to expand...

No one can convert 159 hr into 6 __hours__ without cheating :).
Do you mean 6 __days__ and "so many minutes"?

Do you mean that literally, or would days, __hours__ and
minutes meet your needs?

For the latter, use the custom format dd:hh:mm.

But that only seems to work for less than 32 days.

The format [d]:hh:mm does not seem to work. But the format
[h]:mm does, yielding hours and minutes, not days.
 
J

Jason Morin

The subject and body of your post don't jive. If A1
contains hours, then to convert to days / hours / minutes:

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

HTH
Jason
Atlanta, GA
 
Top