Anonymous
2

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
sumitk.saxena
252

Dear Rinki,
Greetings for the day,
Payment of overtime should be done on twice the rate of wages (inclusive of all allowances) and the calculation formula should be rate of salary / 26/8 * ot hrs * 2 , in case the month should be consist of 30 or 31 days and the second one should be rate of salary / 24 / 8 * ot hrs * 2 , in case the month should be of 28 or 29 days.
Thanks & Regards,
From,
Sumit Kumar Saxena

From India, Ghaziabad
bhupesh7171
14

Yes, you may calculate OT in an excel sheet. First you have to generate an excel sheet having all employees names with there salary, OT hours and calculation of OT as per above formula given by Sumit. This sheet can be used in every month for calculating OT only you have change OT hours and employees leaving and joining.
Regards

From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.