Convert Figure to Time HH:ss

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
 
T

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
 
S

smartin

FerrariWA said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top