Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Caluclate Pounds Per Hour
I need to calculate the number of pounds produced per hour based on the
following fields. Ounce Pack (2.5oz) - Case Count (128) - Start Time (1:20 PM) - End Time (4:12 PM) - Cases Produced (112) I have already calculated the number of pounds produced within the time-frame (2,240). And, I'm already calculating the number of hours it took to produce the the total number of pounds (2.87). Now, (and this is where I need help) I need to figure out how many pounds can be produced based on the above data in one hour. For example, if 717lbs were packed in 2 hours the answer would be 358.50. I hope this makes sense, I really need help on this. Thx so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Caluclate Pounds Per Hour
Use:
=2240/2.87 If 2240 was in A1, and 2.87 was in B1, then use: =A1/B1 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "JK" <jasonk at necoffeeco dot com wrote in message ... I need to calculate the number of pounds produced per hour based on the following fields. Ounce Pack (2.5oz) - Case Count (128) - Start Time (1:20 PM) - End Time (4:12 PM) - Cases Produced (112) I have already calculated the number of pounds produced within the time-frame (2,240). And, I'm already calculating the number of hours it took to produce the the total number of pounds (2.87). Now, (and this is where I need help) I need to figure out how many pounds can be produced based on the above data in one hour. For example, if 717lbs were packed in 2 hours the answer would be 358.50. I hope this makes sense, I really need help on this. Thx so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
calculation of pounds per hour | New Users to Excel | |||
How do I caluclate a function? | Excel Worksheet Functions |