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
2From 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
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
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.
Time-management -7439-4556_187. ppt
Time-management _sent__1__200.d oc