Convert Figure to Time HH:ss

[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

 

[Mike H]

Hi,

With your formula in a1 try

=A1/24

format as time

Mike

 

[T. Valko]

Divide the decimal number by 24:

A1 = 6.87

=A1/24

Format as [h]:mm

So, 6.87 is 6 hrs 52 mins

6:52