Dear All,
Here I am attaching the sheet, which may help you in calculation of Overtime.
In the first sheet, you have to just put the In and Out time of the employee. Based on the working hours, you can list the overtime or the lacking of time in the mentioned collumn. The Over-time will be calculated which is more than 8:00 hrs.
While the another sheet helps in calculating the monthly Over-Time hours of the employees.
Just go through the attachment !!!

From India, Pune
Attached Files (Download Requires Membership)
File Type: xls OT CALCULATION.xls (99.5 KB, 5012 views)

Dear viral sir,

I am sumitra Sahu, have started my recruitment consultant business in cuttack, orissa. As I am fresher in this sector so I need your help over here in following sector,
1. How to write a proposal letter to a company.
2.What would be our commission from that company.
3.What the strategy I should maintain from start to last of a recruitment.
4.From where I can get more & more number of CV.

From India, Calcutta
Hi Sumitra!!!! This is manmeet here, can u just give me your personal email id. Regards Manmeet Executive - HR 9657721121
From India, Pune
Dear Viral Shah,
The sheet attached by you is excellent. But when I enter data in the first sheet it does not get updated in the next sheet. May the link is missing. Please check and revert.
M.V.KANNAN

From India, Madras
Dear Member, Welcome to CiteHR. This thread relates to OT calculation & therefore I would like to suggest you to post your query on similar or separate thread. Regards, R N KHOLA
From India, Delhi
Dear Viral
when i try to enter data in first sheet it wont reflect on other sheet. what the working hrs. in the time sheet coz on that sheet when i put data ( In & Out) overtime /lacking cell is empty while it should be mention 1 hrs or 2 hrs depending upon the out time.
kindly help me for the same as it is very useof for me.
Thanks
Maninder

From India, Pune
Hi,
After entering the in & out time in the respective columns, the column doesn't accept the time in the Overtime or the lacking column. Secondly, no details are reflected in the second sheet after entering date in the first sheet, monthwise. Please guide.
Regards,
Damyanti

From India, Mumbai
Dear All,
Thanks for your valuable suggestions.
I have uploaded the sheet with some better changes. It will automatically calculate the OT if more than 8 hrs. and also updated in the another sheet of Monthly OT of employees.
Just once again download the sheet. ! ! !

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