Sumitk.saxena
Service/manager-hr

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Anonymous
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
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
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
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™