Good evening,

I am trying to create a holiday tracker to track my colleagues holiday allowance.

So my plan is the following.

Cell A1 hours Used
Cell B1 hours remaining
Cell C1 Annual holiday Allowance

So now let say the holiday allowance is 265. John Smith booked 10 hours so that 10 hours will be deducted from the 265 which would be 255. This part is easy enough just by doing

=SUM(A1-C1)

But the problem I have got is if John Smith booked a 5-hour holiday a few weeks later, and you updated the cell “Hours Used” from 10 hours to 5 hours, the total would be then 260. But realistically, it should be 250 instead due to previous holiday . So my question is how would I go about doing this. Any help or advice would be highly appreciated.

Thank you

​Good evening,I am trying to create a holiday tracker to track my colleagues holiday allowance.So my plan is the following.Cell A1 hours UsedCell B1 hours remainingCell C1 Annual holiday AllowanceSo now let say the holiday allowance is 265. John Smith booked 10 hours so that 10 hours will be deducted from the 265 which would be 255. This part is easy enough just by doing=SUM(A1-C1)But the problem I have got is if John Smith booked a 5-hour holiday a few weeks later, and you updated the cell “Hours Used” from 10 hours to 5 hours, the total would be then 260. But realistically, it should be 250 instead due to previous holiday . So my question is how would I go about doing this. Any help or advice would be highly appreciated.Thank you  Read More

​