Over-time Calculation - Xls Download

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 !!!

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.
M.V.KANNAN

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.
Thanks
Maninder

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

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. ! ! !