Divide by Time - ?

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
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!
 
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.
 
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.




George said:
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
Click to expand...
.
Click to expand...
 
Back
Top