Dear leaders This is rinki sharma want to know that can we calculate over time hours in excel sheet by entering only in and out time.
From India
Acknowledge(0)
Amend(0)
2From India
Acknowledge(0)Amend(0)
Payment of overtime should be done at twice the rate of wages (inclusive of all allowances), and the calculation formula should be: rate of salary / 26 / 8 * OT hours * 2. In the case of months with 30 or 31 days, the second formula should be: rate of salary / 24 / 8 * OT hours * 2 for months with 28 or 29 days.
Thanks & Regards,
Sumit Kumar Saxena
From India, Ghaziabad
Acknowledge(0)Amend(0)
Thanks & Regards,
Sumit Kumar Saxena
From India, Ghaziabad
Acknowledge(0)Amend(0)
Yes, you may calculate OT in an Excel sheet. First, you have to generate an Excel sheet with all employees' names, their salaries, OT hours, and the calculation of OT as per the formula provided by Sumit. This sheet can be used every month for calculating OT; you only need to change the OT hours for employees leaving and joining.
Regards
From India, Mumbai
Acknowledge(0)Amend(0)
Regards
From India, Mumbai
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.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls
Amazing excel sheets very very informative.zip
Employee's Compensation Act-2009.pdf