My company is going to a PTO or Paid time off program and employees
will start to ecru time bas3ed on years of service. I am having
difficulty creating a spreadsheet to do this becasue of all of the
variables involved. I was hoping maybe you woudl have some ideas here
that I could poach.
Here are the variables. It is all based on calendar years. So if a
person started in 2007 on 12-30, as of 1-1-2007 they woudl be at the
rate of 1 year since this is when their anniversary falls. Not only
are people ecruing time, but there is also a max time that they can
have. I will put in a crude table to expalin.

Years Weekly Accrual Max hrs
0 1.538461538 120
1 2.153846154 152
2 2.461538462 168
4 3.230769231 248

Then people will use time out of this banked time. I have formulas
that will put the time in, but will not change for the next years
eccrual rate.

Please Help,
Jay