Convert Figure to Time HH:ss

  • Thread starter Thread starter FerrariWA
  • Start date Start date
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
 
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
 
Back
Top