I need the 34.24 hours that is in the 10/2021 pass to show up in the 11/2021 total.
These are scheduled hours.
Most orders start and stop in the same month so it is not an issue.
Some start in one month and end in the next month (ex. start 10/27/21, end 11/5/21).
For these, I have created formulas to show how many hours are in the start month and how many hours are in the finish month (ex. 26.76 hours in month 10 and 34.24 hours in month 11)
How can I get the 34.24 hours (that are actually month 11 hours) that show in month 10 to add to the total for month 11?