Convert 24.1 to days, minutes, hours???

[Wm Rich]

Example: If I calculate that it takes 24.1 days to do a job, how do I
best convert that to 1 day, 2 hours, 24 minutes?

I can do it with a multi-step mathmatical calculation by stripping off
the interger, but there is probably a much easier way in Excel.

Would appreciate help.

Bill

 

[Mike]

=INT(A1/24)&" day, "&HOUR(MOD(A1,24))&" hours, "&MINUTE(MOD(A1,24))&" minutes"

 

[David Turner]

Mike wrote

=INT(A1/24)&" day, "&HOUR(MOD(A1,24))&" hours, "&MINUTE(MOD(A1,24))&"
minutes"

How to adapt to an 8 hour work day?

 

[Ron Rosenfeld]

Example: If I calculate that it takes 24.1 days to do a job, how do I
best convert that to 1 day, 2 hours, 24 minutes?

I can do it with a multi-step mathmatical calculation by stripping off
the interger, but there is probably a much easier way in Excel.

Instead of "converting" it, if you want to "display" it in that fashion, you
can do so with a custom format:

d" days" h" hours" m" minutes"


--ron