Calculation Of Overtime Hours In Excel Sheet Doc Download
Shraddha Jadhav Started The Discussion:

Please help me how to calclaute the overtime excel sheet. iwant the no. of hours calculated like if work starts at 9:00 Am. and if he work till 12:00 am. hw it will be calculated.. Any specific formulas in excel sheet.pls help me out.. will be needful..


Hi Shraddha,


As per my knowledge OT usually calculated as double, let say:
3 hrs x 2 = 6 hrs.

So hopefully no such formulae required. Any seniors can guide please.....!!!

Hi use this formula in excel sheet =SUM(D5-C5+IF(C5>D5,1))., change rows in time mode Prema
Hi Shraddha!
It is very simple to calculate the OT. As per labour laws, it must be @ double the normal rate. As you asked, from 9AM to 12Noon, the number of hours are 3 for which extra work has been done by the employee. Coming to calculation of amount, If the employee's Basic plus DA is supposing 'X' , then the OT payable will be (X/120)*3 OR (X/240)*3*2. In otherwords, if his basic+DA is Rs 6000, then the OT payable per hour is =(6000/120)*3=150. Pls note that out of all components of salary, only the Basic+Fixed DA+Variable DA if any only have to be considered for calculating the Over time. In lieu of Overtime which has to be double the wage rate, it is a practice in some of the organisations to pay at single rate as far as monetary benefit and plus on compensatory off also.

with Regards.

Kashinatham Chitturi.
Hi Shraddha, I am attaching one file which may be meet to your requirement, just put o.t. & change in Basic Salary, it will calculate Over time wages. Thanks & Regards Manoj Yadav
Attached FilesProvided by community member yadavmanoj2006. Register to join your network of peers.
File Type: xls OverTime.xls (35.5 KB, 13491 views)
Can Any body , Explain the formula of Over Time Properly and complete with some Example. Regards Smrins
Dear Yadav, I think your OT calculation formula is worng.Because The OT calculation could be on gross salary and we should pay double amount of daily wage.

The Ot Formula is =ROUND((BASIC+DA)/30/8*2)

The Over Time is normaly double on basic and DA, it should be devided by total days of month and working hours i.e. 8 hrs and then multiply into 2.


not still clear enough, please can someone elucidate in much more clearer terms. with examples of all variables....thanks.
Dear Shradhha, OT is calculated as : (Basic + Sp. All OR D. A.) / No. of days in a month / 8 hrs * OT hrs * 2 Regards Reshma


Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network