Adding Hours automatically

Question

I have a schedule and 60 employees with different earned hours after their time in service. How do I have excel automatically add to existing accumulated hours and continue to do so at the end of the month. Example, If I had an employee with 20 hours, and he earns 8 hours each month, excel will automatically update to 28 first month, 36 second month. Some earn 8 hours, 10 hours, 12 hours and 14 hours. I dont have much experience with formulas so be patient with me. If it can be done with a formula vs a VBA, it would prefer formula, but am willing to try anything to increase knowledge. Also, can I set up another cell so that if an employee uses 10 hours, it will subtract those hours. I need the other cell to show he/she has used so many hours in a given period. Thank you for your time in this matter.

Answer 1

But how do you know how much leave has one taken?

Sorry I've spent already a lot of time and you only come with partial answers. I quit this thread.

Answer 2

Because Employee #1 has taken all of his annual leave except for 12 hours.   That column tells me how many hours they have left or current hours left.

Answer 3

But why has employee #2 177 hours and #1 only 12 hours while he is 34 months longer with you.