Hi - I'm trying to formulate the following rule "A maximum of up to ten (10) unused hrs at the end of one (1) month billing period will be rolled
over for use the following month. There will be no more than a one month accumulation of ten (10) hours rolled over at any time" into a worksheet. Essentially, our contract allows us to bill 32 hours per month but sometimes the techies work fewer hours. We still bill the base 32 hrs, bu we want to allow up to 10 hrs to roll into a given month. If the techies work over the 32 hours, we bill the customer for overage (after applying a maximum of up to 10 hrs of prior month credit).
In my sample, the "Calculated Billable Hours" should be 50 hrs (cell F32) because 60 hrs were worked with the max. credit of 10 hrs applied. Can anyone solve this for me.....??? Many thanks in advance.
Barbara
over for use the following month. There will be no more than a one month accumulation of ten (10) hours rolled over at any time" into a worksheet. Essentially, our contract allows us to bill 32 hours per month but sometimes the techies work fewer hours. We still bill the base 32 hrs, bu we want to allow up to 10 hrs to roll into a given month. If the techies work over the 32 hours, we bill the customer for overage (after applying a maximum of up to 10 hrs of prior month credit).
In my sample, the "Calculated Billable Hours" should be 50 hrs (cell F32) because 60 hrs were worked with the max. credit of 10 hrs applied. Can anyone solve this for me.....??? Many thanks in advance.
Barbara