custom format cell

B

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.
 
R

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.
Click to expand...

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
 
Top