From: scootr on 13 Apr 2010 14:52 Naaa. Not homework Trying to develope a spreadsheet to automatically calculate total time needed based on different speeds per minute, parts needed, and spacing apart. I was just over-complecating things. Thanks everyone. "Bob I" wrote: > Sounds like homework. > > 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? > > . > From: Bob I on 13 Apr 2010 15:16 remove the superfluous information and divide speed of belt by distance between part to get quantity per minute then divide quantity desired by part rate to find time. scootr wrote: > Naaa. > Not homework > Trying to develope a spreadsheet to automatically calculate total time > needed based on different speeds per minute, parts needed, and spacing apart. > I was just over-complecating things. > > Thanks everyone. > > "Bob I" wrote: > > >>Sounds like homework. >> >>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? >> >>. >> First  |  Prev  |  Pages: 1 2 Prev: Return value greater than in LOOKUPNext: I need to show a % of a number