custom format cell

[Brian]

Could someone help me with this one? I am given a
number of 353 hours. It is to be converted into days and
hours. As a fraction, it will become 14 17/24. I would
like the outcome to look like this" 14 days 17 hours".
Can anyone configure this? Thanks ahead of time.

 

[Frank Kabel]

Hi
try
=INT(A1/24) & " days " & MOD(A1,24) & " hours"

 

[Ron Rosenfeld]

Could someone help me with this one? I am given a
number of 353 hours. It is to be converted into days and
hours. As a fraction, it will become 14 17/24. I would
like the outcome to look like this" 14 days 17 hours".
Can anyone configure this? Thanks ahead of time.

If your value will always be less than 32 days, then

=n/24 and you could use the custom format of

d" days "h" hours"

If the value may be 32 days or more, then use Frank's formula.


--ron