Calculation of overtime hours in excel sheet - professional tax
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Employee Compensation & Benefits

Shraddha Jadhav Started The Discussion:

Hello,

Please help me how to calclaute the overtime hours..in 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.. Reply..any..it will be needful..


Regards,

SHraddha

ramkpoddar82 -  Member Since: Jul 2008
Hi Shraddha,

Greetings!

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.....!!!

Regards,
Ram

premambahr -  Member Since: Oct 2008
Hi use this formula in excel sheet =SUM(D5-C5+IF(C5>D5,1))., change rows in time mode Prema

kashinathamch -  Member Since: Oct 2009
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.

yadavmanoj2006 -  Member Since: Oct 2009
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. Join us to learn and grow with your peers.
File Type: xls OverTime.xls (35.5 KB, 10365 views)
smrin -  Member Since: Aug 2008
Can Any body , Explain the formula of Over Time Properly and complete with some Example. Regards Smrins

ksrinivasumba@yahoo.com -  Member Since: Dec 2008
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.

msdarade -  Member Since: Nov 2009
Hi,

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.


Regards,

Meera

bishoppc -  Member Since: Feb 2009
not still clear enough, please can someone elucidate in much more clearer terms. with examples of all variables....thanks.

Reshma Hadshi -  Member Since: Jul 2008
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




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • 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.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    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