Are you trying to determine the length of employment or the duration of the employee's entitlement
pay?
'---
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
(editorial review of special sort add-in (30 ways to sort)
"Odin" <(E-Mail Removed)>
wrote in message
news:8170d73d-05eb-43f0-92bd-(E-Mail Removed)...
> 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.
Similar Threads
