Ok So I did not get an answer tha helpe dme in my previous question so I am
going to try it again. I am not sure if I explained what Iam looking for
correctly.

I am trying to make a formula to calculate an employee's vacation and sick
time accrual. Employees start accruing both after completing their first
sixty days. It is long so bare with me.......

VACATION
Each regular fulltime employee accrues 80 hours per year for the first five
years and 120 hours a year after five years of working service. Each part
itme employee accrues a percentage of the regular accrual based on what
percentage they work.EX-A part time employee who works 32 hours a week is
working 80% of a regular work scheduel and therefore recives 80% percent of
the vacation benefits.

SICK
Each regular fulltime employee accrues six days per year. Partime employees
accrue based on the percentage that they work as written above.

The accruals are calcualted according to the payroll schedule which is
semi-momthly so we have 24 payroll periods a year.

Both vacation and sick time accrual rollover at the end of the year.

I need an excel miracle for this!
--
Afroines