Divide by Time - ?

[George]

Hello

Hopefully you can help...

I have a large Workbook used for calculating department
statistics. I need to divide a numeric value by a cell
containing the time (Formatted [HH]:MM) but when I try to
do a simple divide this will not give me the desired
result.

I have spoken to our inhouse Training team and checked
Google Groups but still unable to find a result, Can
anyone plase help as I'm getting fed up doing them
manually?

Thanks in advance for any help you can offer....

Thanks

George

 

[Andy B]

Hi

Excel stores time as fractions of 1 day - which is 1 (in Excel). It might
help if you explain what you have and what you are trying to get!

 

[JE McGimpsey]

In XL, time is stored as fractional days, (e.g., 3:00 = 3/24 = 1/8 =
0.125). So to get hours, multiply the time by 24.

For instance, if you produce 60 items in 8 hours:

A1: 60
A2: 08:00
A3: =A1/(A2*24) ===> 7.5 (when formatted as General)

or 7.5 items per hour.

 

[Guest]

Thats Fantastic - Thanks for that


George

-----Original Message-----
In XL, time is stored as fractional days, (e.g., 3:00 = 3/24 = 1/8 =
0.125). So to get hours, multiply the time by 24.

For instance, if you produce 60 items in 8 hours:

A1: 60
A2: 08:00
A3: =A1/(A2*24) ===> 7.5 (when formatted as General)

or 7.5 items per hour.

Hello

Hopefully you can help...

I have a large Workbook used for calculating department
statistics. I need to divide a numeric value by a cell
containing the time (Formatted [HH]:MM) but when I try to
do a simple divide this will not give me the desired
result.

I have spoken to our inhouse Training team and checked
Google Groups but still unable to find a result, Can
anyone plase help as I'm getting fed up doing them
manually?

Thanks in advance for any help you can offer....

Thanks

George

.