F
FerrariWA
Hello,
Does Excel have the ability to convert a number to time?
For example, I want to display 6.87 as 6 hours and the minutes 87 calculates
to?
I know that if the figure was 6.50, then it would mean 6 hours 30 minutes.
The full calculation is as follows:
11 agents work 37.25 hours a week
1 agent works 20 hours
1 agent works 15 hours
In order to gain the Paid Hours , summarise the total number of hours
(11x37.25, 1x20,1x15 = 446.75) against the number of days worked in the week
(5) then divide by number of agents (13) giving me 6.87 paid hours per day.
Thanks,
WA
Does Excel have the ability to convert a number to time?
For example, I want to display 6.87 as 6 hours and the minutes 87 calculates
to?
I know that if the figure was 6.50, then it would mean 6 hours 30 minutes.
The full calculation is as follows:
11 agents work 37.25 hours a week
1 agent works 20 hours
1 agent works 15 hours
In order to gain the Paid Hours , summarise the total number of hours
(11x37.25, 1x20,1x15 = 446.75) against the number of days worked in the week
(5) then divide by number of agents (13) giving me 6.87 paid hours per day.
Thanks,
WA