Compiling a production spreadsheet, and need assistance.

Hi, I am compiling a production spreadsheet, involving various hourly targets, and cumulative targets.

I have a formula in place already, whereby an hourly target is calculated (over a 12hr shift), and there is a cell for actual product produced.

What I wanted, was a formula whereby any negative production is to the remaining hours.

For example. If the hourly target is 257 (although this is variable), but only 192 units are produced, I would like a formula whereby the next 11hrs are 256+6 (the deficit divided by 11 remaining hours) and so on.

This sounds fairly straightforward, but believe me, it is difficult.

If this is even possible on excel, then please advise.

Hi Falbrav,

I'm thinking if the hourly target is in Column A and the produced is column B then in column C

=IF(A2>B2,SUM(A2-B2)/11+A2) returns 262.91

Thanks.

I will try this, and get back to you.

Thanks for your help, but unfortunately, this doesn't seem to work because if there is only 7 hrs of the shift remaining, it still calculates for 11, so the hourly targets are too low resulting in a production shortfall.