I am working on an allocation project that requires accumulation of cumulative flying hours into approximate 300 hour groups for allocation of the expenses associated with that group of hours.
I have used the Floor formula to divide the cumulative hours by the 300 allocable hours and when the integer portion of the answer changes (e.g. 0 to 1, 1 to 2, etc.) that gives me a rough grouping of 300 hours, but not exactly what I need as I may have 318 hours in the first group but only 295 hours in the second group (because 318 + 295 = 613, a second group will have been created when hitting the 600 cumulative hour mark).
How can I get at least 300 hours in the first group plus an additional 300 hours in the second group (in my example, a break at 318 hours for the first group and the next break not until at least 618 cumulative hours)?
I have used the Floor formula to divide the cumulative hours by the 300 allocable hours and when the integer portion of the answer changes (e.g. 0 to 1, 1 to 2, etc.) that gives me a rough grouping of 300 hours, but not exactly what I need as I may have 318 hours in the first group but only 295 hours in the second group (because 318 + 295 = 613, a second group will have been created when hitting the 600 cumulative hour mark).
How can I get at least 300 hours in the first group plus an additional 300 hours in the second group (in my example, a break at 318 hours for the first group and the next break not until at least 618 cumulative hours)?
