Dear Seniors,
Please let me know if overtime is applicable and how to calculate it on Excel as per employees' salary. The warehouse is in Mumbai.
Work Time:
Mon-Fri - 11:30 am to 8:00 pm (Ladies leave at 7:30)
Saturday - 11:30 am to 6:30 pm
This includes lunchtime of half an hour. So, twice a month, they have to come early, around 7/8 am, and sometimes leave around 10 pm because of shipments. Do we have to pay them overtime for the same? If yes, then what will be the calculation in Excel?
From India
Acknowledge(0)
Amend(0)
2Please let me know if overtime is applicable and how to calculate it on Excel as per employees' salary. The warehouse is in Mumbai.
Work Time:
Mon-Fri - 11:30 am to 8:00 pm (Ladies leave at 7:30)
Saturday - 11:30 am to 6:30 pm
This includes lunchtime of half an hour. So, twice a month, they have to come early, around 7/8 am, and sometimes leave around 10 pm because of shipments. Do we have to pay them overtime for the same? If yes, then what will be the calculation in Excel?
From India
Acknowledge(0)Amend(0)
On any day on which the employees work for more than 8 hours (excluding the interval for lunch, say half an hour), you have to pay overtime wages at double the rate. If the employees come at 8 am, then for that day, the scheduled working hours are from 8 am till 4 pm. If an employee leaves at 6 pm, he should get overtime wages for 2 hours. If on a day an employee comes at 11:30 am and leaves at 10 pm, he should be entitled to 2 hours of OT for that day.
In the salary sheet itself, there should be columns for the number of OT Hours, OT rate per hour, and OT Wages. The OT rate per hour should have a formula applied so that it will reflect the hourly rate at double. The OT wages column should also have a formula to multiply the overtime hours by the OT rate. Once you input the number of hours, the OT wages will be calculated and should be included in the additions (Basic, DA, HRA, Conveyance, Special pay, etc.) to calculate the gross wages.
If you have single OT (for those who have taken leave and not worked for 48 hours but have done overtime after having taken leave for one or two days), you can split the column for overtime hours and rate with separate columns for "single rate" and "double rate".
From India, Kannur
Acknowledge(0)Amend(0)
In the salary sheet itself, there should be columns for the number of OT Hours, OT rate per hour, and OT Wages. The OT rate per hour should have a formula applied so that it will reflect the hourly rate at double. The OT wages column should also have a formula to multiply the overtime hours by the OT rate. Once you input the number of hours, the OT wages will be calculated and should be included in the additions (Basic, DA, HRA, Conveyance, Special pay, etc.) to calculate the gross wages.
If you have single OT (for those who have taken leave and not worked for 48 hours but have done overtime after having taken leave for one or two days), you can split the column for overtime hours and rate with separate columns for "single rate" and "double rate".
From India, Kannur
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.
Overtime calculation- weekly hours of work.PDF
SALARY SHEET CALCULATION.xls