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.