Formula to calculate the number of days required

Hello judgeh59,

Thanks a lot for your response.

The values do not match the values I have in the file I attached.

In AY4, it should return 8 as we need 8 days in which 7 days at 2hrs/day and on 8th day at 1hr/day to cover the total of 15hours.

Also, in AZ5, the value should be 1, as there is 1hour remaining on Day9 (1 hour on Day8 + 1 hour on Day 9 for a total duration of 2 hours for that item).

Request your help.