I am making an apprenticeship hour log. In B2, for example, I have hours needed as 2200, they put in how many hours worked in that area in B3. I can subtract that amount and show it in B4 but how do I keep the new amount in B4 for the next week. I.E. 2200 hours needed (B2) 10 hours worked in B3 new number in B4 2190. I need to keep the 2190 for the next week. I can't figure out how to keep it 2190 when B3 clears? Help?
Solved by D. D. in 18 mins