# Help with excel formulas

Copper Contributor

# Help with excel formulas

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

2 Replies

# Re: Help with excel formulas

Subtracting within the same cell is tricky:

• You won't have a history of hour's used, and because of that:
• It's not easy to spot and to correct a mistake, or an alteration.

I'd do it - for example - like this:

The formulas in column B are:

You can fill down the formula from B3 downwards.

# Re: Help with excel formulas

Thank you, I had a feeling this would be the case. Thanks the for the advice 🙂