Automatic updating of a time bank help

[dwelch77]

Hello all,

I've been a long time lurker and just opened my account today. Usually I can find what I'm looking for on my own, but this problem seems to be unique. Or I just don't know how to ask the question right.

I'm trying to create a spread sheet that will automatically add and subtract time from a vacation bank or sick leave bank as it is earned or used. For example I earn 8.308 hours of vacation time every two weeks and 11.0756 hours of sick leave. I would like the formula to automatically update every payday which is every two weeks on friday, but also update if I take a few hours off in the middle of the week. I'm afraid what I'm asking excel to do is impossible. I've attached the spreadsheet in hopes that the way it's laid out makes more sense of my questions.

Thank you anyone who can help!