View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Calculate parts per hour on rotating line

7.5 parts per minute.

=500/7.5 returns 66.66667 minutes


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 09:46:06 -0700, scootr
wrote:

There is a 700 feet rotating conveyor.
Moving at a rate of 7.5 feet per minute.
I know it takes 93 minutes to make one revolution.

How long will it take to get 500 parts off the line?
The parts are spaced 1 foot apart.

I need a formula that can calculate this. Can somebody help me?