Over-time Calculation - Xls Download - CiteHR
Prime Sponsor - FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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 !!!

Attached Files
Membership is required for download. Create An Account First
File Type: xls OT CALCULATION.xls (99.5 KB, 4372 views)

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.
Hi Sumitra!!!! This is manmeet here, can u just give me your personal email id. Regards Manmeet Executive - HR 9657721121
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.
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
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.

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.
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. ! ! !
Prime Sponsor - Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
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 @ 2019 Cite.Co™