G

#### Guest

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!