Convert Figure to Time HH:ss
 

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

Convert Figure to Time HH:ss
 

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

Convert Figure to Time HH:ss
 

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

--
Biff
Microsoft Excel MVP


"FerrariWA" wrote in message
...
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

Convert Figure to Time HH:ss
 

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

Excel already stores time (and dates) as numbers but the scale is
different from your requirement.

In Excel, whole numbers are day units. So, to convert your units (hours)
to Excel-friendly days, simply divide your units by 24.

Then format the result as desired. Check out the pre-fab Time
formats--there is one equivalent to [h]:mm:ss.