How to process surplus amounts in values

[pshaw436]

I am working with schedule data at my facility that is used to make various projections.

Our scheduling software organizes production runs by run and not by day which leads to some challenges. For example:

If we have a 60hour run of one product that begins at 7/17/23 00:00, then in the report, 7/17/23 will read 60 hours, 7/18/23 will read 0 hours, and 7/19/23 will read 12 hours of whatever product was made next.

This creates challenges when attempting to provide accurate projections. I need 7/17 to read 24, and then the overflow needs to be distributed among subsequent days until it's used up (7/18 should read 24 and 7/19 should read 12 hours of the product and then 12 hours of whatever followed).

For simplicty we can use the data set below.

Thanks,
Parker