Sick, vacation and Personal leave excel

I am trying to make a spreadsheet in excel that calculates the following

1- sick time

2- vacation time

3- Personal leave

I know absolutely nothing about writing formulas in excel. Hopefully someone here could lend a hand. I get paid bi-weekly and accumulate (4) hours of sick time and (6) hours of vacation every pay period. On certain holidays, I accumulate an additional (8) hours of vacation time. On my anniversary date of employment, I receive 40 hours of personal time

Pay week starts on a Thursday and ends on a Wednesday.

How do I set up a spread sheet with the above information, that will add said hours each pay period and deduct 8 hours of each time category utilizing the following:

S for sick time

V for vacation time

P for Personal time

The end goal is to see how many hours I have on the books every pay period.