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 !!!
12th March 2011 From India, Pune

Attached Files (Download Requires Membership)

OT CALCULATION.xls (99.5 KB, 4875 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.
12th March 2011 From India, Calcutta

Hi Sumitra!!!! This is manmeet here, can u just give me your personal email id. Regards Manmeet Executive - HR 9657721121
12th March 2011 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
13th March 2011 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
13th March 2011 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

14th March 2011 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
14th March 2011 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. ! ! !
15th March 2011 From India, Pune