meenu.m1@citehr.com
12

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

From India, Lucknow
vipinmanav
32

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

From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls Attendance(Rev1[1].0 B1).xls (819.0 KB, 5259 views)

deepti bhardwaj
1

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
From India, Sultanpur
dinesh-yadav1
1

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
From India, New Delhi
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.