Production Pace Calculation

[ClariceGrant]

I am a production manager for a company that is pretty behind the times when it comes to spreadsheets. We have a daily production log with a pace calculator that only works for the first 3 rows and then the formula doesn't work because it doesn't take into account all of the calculations above it (just the 2 totals above it) I need to calculate the pace per hour on a regular basis and have been trying to fix the chart but haven't used formulas in excel since university in 1997. Please help. The way my chart is laid out is as follows...
Time of day, Number of production hours, Product size 1, size 2, size 3, size 4, size 5, size 6, total product, current production pace

The product is all the same thing but graded by size and I need to be able to punch in our current totals and get the current pace per hour. Please help!!! Thanks in advance.

[Sam Capricci]

You'll probably get more help if you attach a sample sheet with enough data to show what you deal with and your desired results. Use "Go Advanced" to attach a sheet.

[ClariceGrant]

I just tried to attach it but for some reason after I upload it does not show up in my attachments list.

[Glenn Kennedy]

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.