Caluclate Pounds Per Hour

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

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!
 
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!
 
Back
Top