meenu.m1@citehr.com
12

Dear All Please send me the attendance format in Ms Excel with the formula of Over time. thanks
From India, Lucknow
rajeevdixit
111

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)
From India, Bangalore
vipinmanav
32

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

From India, New Delhi
vipinmanav
32

Dear Meenu, go for the option of Gross salary while calculating the overtime becoz, ESI will be deducted on Overtime. Regards Vipin
From India, New Delhi
Srinivasa Araveti
13

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
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls OT.xls (95.0 KB, 4709 views)

vijayvashisth
13

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

From India, Jaipur
virenderhr
2

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.

From India, Delhi
virenderhr
2

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.

From India, Delhi
richrachna
6

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.

From India, Hyderabad
Saurabh Bhatnagar
3

The appended presentation on overtime will be helpful in understanding it better.
From India, Delhi
Attached Files (Download Requires Membership)
File Type: ppt Overtime.ppt (48.0 KB, 2950 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.