Deepti Bhardwaj
Hr Executive
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Dear all,
could you send me the attendance format including over time column.because where i work there only those employees are geting the Over time whose salary is below 5000/-. if those emplyees whose salary is above 5000/- in that case if he will do OT then he will adjust that OT by taking compensatory off.
so that iam very confuse that how we will adjust their compensatory off & how we will find out the Total OT whose salary is less than 5000/- in a single attendance formate ? what formula we will put in that attendance sheet that automatically it will calculate.
Thanks
Nirmala

Dear Nirmala,
Pls don't get confused,
formula for calulating OVerime is
= Gross salary p.m./26/8*OT hrs*2
It is given double from the double rate, ESI is deducted on this and u can give max overtime to an employee of 51 hrs in a quarter above the cap is against the law.
for a attendance format, m attaching a format for ur reference.
OR do one thing make a separate sheet of people whose salary is less than 5000 named overtime calculation.
Regards
Vipin


Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance(Rev1[1].0 B1).xls (819.0 KB, 4951 views)

Dear All please help me i have to make salary sheet with attendance & overtime in excel on daily basis. please suggest me or provide me excel format asap. Regards Deepti Bhardwaj
Dear plaese help me i have to make daily basis attendence with overtime in excel please suggest me or provide me excel format asap Regards Dinesh yadav
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™