#query {background: #ebf5fd; color: #4f4f4f; letter-spacing: 1px; padding: 5px; border: 1px #001b31 solid; text-indent: 3%; font-size: small;} form#search_query { color: #FDFCFB; text-align: left; margin: 0px; }
Srinivasa Araveti
Hr, Ir, Payroll, Statutory & Compliance,
Saurabh Bhatnagar
Hr Generalist
Rajeevdixit
Hr , Personnel & Admin
Vijayvashisth
A T Raja
Manager
Richrachna
Gamut Hr
Virenderhr
Gen. Hr
+3 Others

Dear All Please send me the attendance format in Ms Excel with the formula of Over time. thanks
28th February 2009 From India, Lucknow
Hello , Its simple .it is calculated on basic . so basic /30/8 = hourly rate hourly rate x numbers of extra time hours worked . Hope its of help to you regards Rajeev Dixit (09901436123)
28th February 2009 From India, Bangalore
Dear Meenu,
The formula is as follows:-
=Total Gross/26/8*ot hrs*2, 2 means that we have to give double overtime from the normal rate or u can go with simple calulation by giving overtime at the rate of Rs20 per hour.
It means for e.g. if X worked for extra 13 hrs as ovetime.
His monthly gross is Rs 3640 P.m. then the calculation would be
=3640/26/8*13*2= Rs455/-
Regards
Vipin
28th February 2009 From India, New Delhi
Dear Meenu, go for the option of Gross salary while calculating the overtime becoz, ESI will be deducted on Overtime. Regards Vipin
28th February 2009 From India, New Delhi
Dear Meenu, The formula is Basic + DA/30/8*No. of hourse extra worked*2 find the XL file with formula with best regards Srinivasa Araveti
1st March 2009 From India, Bangalore

Attached Files
 Membership is required for download. Create An Account First OT.xls (95.0 KB, 4158 views)

Dear Ms. Nirmla,

From the legal point of view, Mr. Vipin is right.

Overtime is to be paid double of "Ordinary rate of wages" under sub-section(1) of 59 of Factory Act 1947 thus I would like to request those who are calculating the overtime on "Basic Salary" to please go through sub-section (1), (2) & (3) of 59 under under said act.

Note:

Overtime rate:- It shall be deemed to be equivalent to the daily average of their full-time earnings for the day on which they actually worked on the same day.

Secondly, overtime is being calculated on 26 days not on 30 days because in factory act days means 26 and minimum wage also calulated on 26 days.

So, it's my request to those who are calculating the overtime on Basic and on 30 days pls discuss the same with your legal advisor, if have and get his openion so that you could compliance accordingly.

If have any query can contact me:
Regards,
From-
Vijay Vashisth
Manager HR
09992334610

2nd March 2009 From India, Jaipur
Dear Nirmala,
As per factory act we have to calculate the overtime on Gross Salary and with considering 26 days. And we have to deduct the ESI amt. also on the overtime.
the formula is -
=Total Gross/26/8*No. of OT hrs*2
(As per act, we have to give ot double to the rate)
Overtime:
Where a worker works in a factory for more than nine hours in any day or for more .than forty-eight hours in any week, he shall, in respect of overtime work, be entitled to wages at the rate of twice his ordinary rate of wages.
The total number of hours of overtime shall not exceed fifty for anyone quarter(3 months).
Thanks & Regards,
Virender Singh.
2nd March 2009 From India, Delhi
Dear Nirmala,
As per factory act we have to calculate the overtime on Gross Salary and with considering 26 days. And we have to deduct the ESI amt. also on the overtime.
the formula is -
=Total Gross/26/8*No. of OT hrs*2
(As per act, we have to give ot double to the rate)
Overtime:
Where a worker works in a factory for more than nine hours in any day or for more .than forty-eight hours in any week, he shall, in respect of overtime work, be entitled to wages at the rate of twice his ordinary rate of wages.
The total number of hours of overtime shall not exceed fifty for anyone quarter(3 months).
Thanks & Regards,
Virender Singh.
2nd March 2009 From India, Delhi
Hi All,
Thanks for these informative posts on Over time calculation. Actually I am working in IT sector and was looking out for this information. As of now we are providing Late stay convance to such employees.This would help me out in drafting the policy in the correct way. Do let me know any further detail to be know while considering IT sector.
2nd March 2009 From India, Hyderabad
The appended presentation on overtime will be helpful in understanding it better.
2nd March 2009 From India, Delhi

Attached Files
 Membership is required for download. Create An Account First Overtime.ppt (48.0 KB, 2131 views)

Dear Sir,
Please send me the OT calculation in Excel Sheet. Situation is as follow:
We are running the Production in Quota Basis.We have 2 Line for the production of IMFL of Different Sizes Qts Pints and Nips
EG
Quota is Production of 500 C/s for Qts in 8 Hrs with 42 Labours.
Now
1.the Labours finished the quota in 6hrs and in two Hrs they do extra Production
2. if labour is less than 42 quota is reduced by 20 c/s , distrubution of OT.
Kindly help me.
Girish N Chaturvedi
+919051812281
5th March 2009
superb - thanx for calculation. Very glad. excellently prepared. Now only i came to know the calculation after three decades of experience !!!!
6th March 2009 From India, Coimbatore
Dear Mr. Virender Singh, As you mentioned above he (workman) shall be entitled to wages (not OT) at the rate of twice his ordinary rate of wages. Is it right? Regards, Vilas
8th October 2016 From India, Ajmer
This is just a wrong presentation ..it should be removed from the site. there is no term like non statutory OT. No provision of 1.5 times OT
22nd March 2017 From India, undefined

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)