Calculation of overtime hours in excel sheet
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

Calculation of overtime hours in excel sheet

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, 9836 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



Found This Useful? +Vote Up This Page 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.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


10
LIKES

17892
VIEWS

21
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


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

Share »

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