How to write fast formula for sick leave
Hi All,
can any one help me to develop fast formula regarding to calculate sick hours
requirement is like
accrual starts the day the employee hired .full time employee works 38.5 hours per week & full time employees are entitled to 10 days paid sick leave sick leaves accrue 7 hr per month
sick leave accrue 1st of every month and employee not permitted to use sick leave before it is accrued
part employee accrual rate should be depends on his working hours sick leave not paid upon termination and sick leave will continue to accrue even if employee is on leave or vacation
requirement is like
accrual starts the day the employee hired .full time employee works 38.5 hours per week & full time employees are entitled to 10 days paid sick leave sick leaves accrue 7 hr per month
sick leave accrue 1st of every month and employee not permitted to use sick leave before it is accrued
part employee accrual rate should be depends on his working hours sick leave not paid upon termination and sick leave will continue to accrue even if employee is on leave or vacation
Tagged:
1