Over Time - Excel Sheets

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.

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

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