Convert Vacation Hours into Days/Minutes

[meppwc]

Does Excel have a function to convert hours off into days (8 hour day) and minutes?

For example
If I have 51 hours of vacation
If I divide that by 8, that equals 6.38 days off
So I have 6 days off + .38 of a day.
How would .38 equate to hours/minutes?

 

[meppwc]

Giving this some thought.........
51 hours of vacation is the equivalent of 6 eight-hour days off with an additional 3 hours off left over
So if there is a way of using QUOTIENT and MOD in the same formula that might give the results that I am looking for.
The result that I am hoping for with a formula is "6 Days 3 Hours". All in the same cell.

 

[Joe4]

For an entry in cell A1 (i.e. 51 hours), try this:

=INT(A1/8) & " Days " & MOD(A1,8) & " Hours"

Note that this just takes days and hours into consideration, not minutes.

 

[meppwc]

That is perfect Joe4.............exactly what I was needing........thanks so much

 

[Joe4]

You are welcome.