Dear My seniors,
Please help me on the following issue.
Our company have leaves of Casual and Medical leaves.
Casual leave 10/year
Medical leave 12/year (1/month)
In this regard I want to know the calculation of total number of casual and medical leave availed for an employee who start from the month of March.
Is there any formula available to calculate leaves on pro rata basis.
Please guide me on this regard. Its urgent
Soju
From India, Kochi
Acknowledge(0)
Amend(0)
6Please help me on the following issue.
Our company have leaves of Casual and Medical leaves.
Casual leave 10/year
Medical leave 12/year (1/month)
In this regard I want to know the calculation of total number of casual and medical leave availed for an employee who start from the month of March.
Is there any formula available to calculate leaves on pro rata basis.
Please guide me on this regard. Its 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:
Months x Entitlement/year
12
i.e. to say his Casual leave entitlement will be = 10 x 10 / 12 = 8 days
and his Medical leave entitlement will be = 10 x 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)
Months x Entitlement/year
12
i.e. to say his Casual leave entitlement will be = 10 x 10 / 12 = 8 days
and his Medical leave entitlement will be = 10 x 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 numbers of leaves on total working days and get average accordingly,Always start the leaves from Jan to Dec,if you are calculating from March then no problem.
Best Regards
Sajid Ansari
9958404503/9899775578
From India, Delhi
Acknowledge(0)Amend(0)
You should calculate numbers of leaves on total working days and get average accordingly,Always start the leaves from Jan to Dec,if you are calculating from March then no problem.
Best Regards
Sajid Ansari
9958404503/9899775578
From India, Delhi
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Lost Baby Information-ver y urgent.doc
Urgent vs Important work.xls