This is the example im working with. C has the input of work in hours on a particular day. E has the amount of available manhours on a day. When E<c the="" work="" goes="" to="" following="" day.="" treating="" input="" on="" a="" day="" as="" batch,="" i="" want="" find="" out="" when="" whole="" set="" is="" completed.<="" span=""></c>
Im looking for a way in excel that calculates the amount of days it would take for a batch to be completed and then continue with the input for the following day and do the same. Example: the input of 1/4/2016 would be completed on 1/5/2016 with 6 hours to spare. These 6 hours would then be used to start on the input of 1/5/2016. The remaining 7 hours of work of 1/5/2016 would then go to 1/6/2016 and so on.
Is there a way that this can be calculated in excel so I don't have to do this manually? This is a small example of 100 days but the total I'm working with is a lot larger.
