Each month 1.75 hours are earned, each week time is subtracted from the previous month’s balance. The maximum number of hours that can be accumulated is 21.
I figured out that =IF(G7>=21,"21") will have it return 21 if the balance is over 21 hours. I can’t seem to figure out how to have it show actual number of hours when they are less than 21. I probably need to add a then statement but I can’t get it added without an error.