Formula to calculate the number of days required

Hello,

I have a worksheet in Excel 2003 where I calculate the number of days a particular item can be used depending on how many hours it is available in a day.

1) In Columns AY and AZ, I need the formula to return the values that I have updated.

Explanation: In row 4, the Item1 of Cat1 is available for 2 hours/day and we need it for total of 15hours. This would mean that I use this Item1 for 7 days at 2hrs/day and on 8th day I use it for 1hr/day to make it to a total of 15hours. The remaining 1 hour on the 8th day, I need to use Item2 of Cat1 and so on.

Please help.

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.