Need help with excel formulas!

[DUKETRAC]

I am using the excel spreadsheet employee attendance.

I am also using Microsoft Office version Version : 18.2110.13110.0

I am trying to add one hour per month for PTO (personal time off) and cap out at 12 hours.

I know the formula I am using isn't right, but was trying to make it work. lol 
Plus add yearly vacation time, but I would like it to begin on the employees anniversary day.  I am no pro at excel, but was trying different formulas.

Employee Attendance Record 

Thanks for any and all help that I can get.

[#2]

@DUKETRAC 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place.

Please include the following info to help others answer your question:

Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)