A number of questions:

time accrual. Employees start accruing both after completing their first
sixty days.

So the employee starts to accrue vacation time at Start date +60 days. When
he/she gets to have 5 years service is the date the start date + 5 years,
Start date + 60 days + 5 years, January 1 of the year in which the employee
will attain 5 years service or January 1 of the year following when the
employee has 5 years service?

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

What, (in the spreadsheet) designates that the Part-time employees are
part-time?

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

How can we tell when a payroll period starts, ie Does it always start in the
1st Monday of the year? or when does it start?

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

How do you "write off" vacation time when it is taken? ie if an employee
has 20 hours rolled over from last year and has accrued 24 hours this year,
takes 40 hours vacation do you want to simply enter the vacation in one box
and have it reduce the total accrued time? If so that will, I think require
a VBA solution. Doing it that way however means that there will be no
history of past vacations taken.

Do you want the rollover to continue year on year or do you want one sheet
per year?

A brief description of how the spreadsheet is laid pout would also be
helpful.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"AFroines" wrote in message
...
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