View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Calculate Pounds Per Hour

Pounds produced (2,240) / Hours it took (2.87)

Answer: 780.49 lbs per hour.

Note that you hours it took, in formula, is
=(End time - Start time)*24
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JK" wrote:

First of all, I posted a this same question earlier, and I received a
response, but I'm unable to open it. I also tried to search for my post in
the Excel Comm. but I can't find it. If anyone has any idea why - I'd love to
know.

Anyway, this is what I need to do. I need to calculate the number of pounds
produced per hour based on the following fields.

Start Time (1:20), End Time (4:12), Pounds Produced (2,240), Hours it took
to produce lbs (2.87).

I need to know how many pounds can be produced in one hour. I can't figure
this out!

Thanks,
Jason