Dear My Seniors,
Please help me with the following issue. Our company has two types of leaves: Casual and Medical leaves. Casual leave is 10 days per year, while Medical leave is 12 days per year (1 day per month).
I would like to understand how to calculate the total number of Casual and Medical leaves availed by an employee who starts in March. Is there a formula available to calculate leaves on a pro-rata basis?
Please guide me on this matter. It's urgent.
Soju
From India, Kochi
Acknowledge(0)
Amend(0)
4Please help me with the following issue. Our company has two types of leaves: Casual and Medical leaves. Casual leave is 10 days per year, while Medical leave is 12 days per year (1 day per month).
I would like to understand how to calculate the total number of Casual and Medical leaves availed by an employee who starts in March. Is there a formula available to calculate leaves on a pro-rata basis?
Please guide me on this matter. It's urgent.
Soju
From India, Kochi
Acknowledge(0)Amend(0)
dear what formulae you need you calculate these on prorata basis.what is your doubt. j s malik
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Thanks Like if an employees leaves starting from Feb What would be the total amount of leave he entitled to get in the particular year? (Medical and Casual)
From India, Kochi
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
You can use the following formula for calculating Casual & Medical leave:
[ text{Months x Entitlement/year} ]
[ 12 ]
i.e. to say his Casual leave entitlement will be = ( 10 times 10 / 12 = 8 ) days
and his Medical leave entitlement will be = ( 10 times 12 / 12 = 10 ) days
(ignore the fraction if it is less than 5 and increase by a day if it is > 5)
I hope the above clarifies your need.
Regards
From India, Delhi
Acknowledge(0)Amend(0)
[ text{Months x Entitlement/year} ]
[ 12 ]
i.e. to say his Casual leave entitlement will be = ( 10 times 10 / 12 = 8 ) days
and his Medical leave entitlement will be = ( 10 times 12 / 12 = 10 ) days
(ignore the fraction if it is less than 5 and increase by a day if it is > 5)
I hope the above clarifies your need.
Regards
From India, Delhi
Acknowledge(0)Amend(0)
Yes, you should calculate the number of leaves on total working days and get the average accordingly. Always start counting the leaves from January to December. If you are calculating from March, then there is no problem.
Best Regards,
Sajid Ansari
9958404503/9899775578
From India, Delhi
Acknowledge(0)Amend(0)
Best Regards,
Sajid Ansari
9958404503/9899775578
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf
Leave Encashment & Salary Calculation.xls x