Thread: How do I set up a formula for parts (or units) per hour?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ender-DI
 
Posts: n/a
Default How do I set up a formula for parts (or units) per hour?
If only 13 total parts were produced, how is it supposed to read 48.75 parts
per hour?

It took 6 hours, 24 minutes to produce 13 parts. I need to show that that
breaks down to 2.166 parts per hour.


I think column C ought to be showing 48.75

You need to use the formula

=b1/(a1*24)

Reply With QuoteReply With Quote