Hi,

With your formula in a1 try

=A1/24

format as time

Mike

"FerrariWA" wrote:

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