calculating Sick pay entitlement

  • Thread starter Thread starter Odin
  • Start date Start date
O

Odin

Hi

I am trying to calculate the entitlement to Occupational (company)
sick pay (different and sepaarate to Statutory sick pay), using excel
for members in my team.

Our entitlement depends on length of employment i.e:

Under 12 months:
Entitlment to full pay = 0
Entitlent to half pay = 0

12 months to 2 years:
Entitlment to full pay = 1 month
Entitlent to half pay = 1 month

2 years to 5 years:
Entitlment to full pay = 3 months
Entitlent to half pay = 3 months

Over 5 years:
Entitlment to full pay = 6 months
Entitlent to half pay = 6 months

I am working this out from the date they started working (Service
reference date)

A working day is 7.5hrs, 5 days a week (1950 hrs a year) pro rataed
for part time working.

I have failed using nested formualae and was hoping that VBA code
might be the way but 'am hopeless at that.

Any help, clues, pointers would be appreciated.
 
Back
Top