Drats.
I've been going over this time and again but am just not good enough to figure this out. Please help.
I've got a vacation sheet. Sometimes people take whole days ... sometimes half days ... and sometimes hourly vacation.
Some people are union and work a different number of hours than others.
So, CELL G111 has a drop-down list to choose how many hours this person works in a shift.
I've got it totaled where:
A person who works 7.5 hours in a day
Takes TWO WHOLE DAYS = 15 Hours
Takes 1/2 DAY ................. = 3.75
Takes 1 Hour .................... = 0.1333333333
I TOTAL these up to equal = 18.883
Then, I divide that sum by the variable number of hours (in cell G111) this person works per shift. In this case (7.5 hours) ... which gives me a total of = 2.51778
Now ... notice my total (2.51778) represents (2 and 1/2 days .... )
How can I get this number to cleanly report (2.5 days 1 Hour)
There is more to this which is why I'm going this long route ... but can some Excel genius help me?
Thank you.
I've been going over this time and again but am just not good enough to figure this out. Please help.
I've got a vacation sheet. Sometimes people take whole days ... sometimes half days ... and sometimes hourly vacation.
Some people are union and work a different number of hours than others.
So, CELL G111 has a drop-down list to choose how many hours this person works in a shift.
I've got it totaled where:
A person who works 7.5 hours in a day
Takes TWO WHOLE DAYS = 15 Hours
Takes 1/2 DAY ................. = 3.75
Takes 1 Hour .................... = 0.1333333333
I TOTAL these up to equal = 18.883
Then, I divide that sum by the variable number of hours (in cell G111) this person works per shift. In this case (7.5 hours) ... which gives me a total of = 2.51778
Now ... notice my total (2.51778) represents (2 and 1/2 days .... )
How can I get this number to cleanly report (2.5 days 1 Hour)
There is more to this which is why I'm going this long route ... but can some Excel genius help me?
Thank you.