Converting Weight in a Time

Here you go, i think this should work.

The formula is: =(Target Tons*lbs per ton(2000))/(Seconds per day/Seconds per Stroke)

In my attached spreadsheet it's: =(E2*B4)/(B6/B3)

Hope that helps.

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

Apologies if i stepped out of bounds.

Thanks for adding the detail.

I think this is the math you are looking for

500 ton * 2000 = 1,000,000 Lb / 425 per stroke = 2352,94 strokes
and 1/2353 strokes is once every 36.72 seconds for 24 hr production
the last stroke in this case is 0,94*425=400lbs to get to 500t exactly

Edit: to clarify, a 24 hours = 1 day in excel equals numericvalue 1 that is why dividing 1 by the number of strokes gives the outcome of seconds interval

see also attachment