Dear All,
Here I am attaching the sheet, which may help you in the 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 lack of time in the mentioned column. The overtime will be calculated, which is more than 8:00 hrs.
While the other sheet helps in calculating the monthly Overtime hours of the employees.
Just go through the attachment!!!
From India, Pune
Acknowledge(0)
Amend(0)
74Here I am attaching the sheet, which may help you in the 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 lack of time in the mentioned column. The overtime will be calculated, which is more than 8:00 hrs.
While the other sheet helps in calculating the monthly Overtime hours of the employees.
Just go through the attachment!!!
From India, Pune
Acknowledge(0)Amend(0)
Dear Viral Sir,
I am Sumitra Sahu and have started my recruitment consultant business in Cuttack, Odisha. As I am new in this sector, I need your help with the following:
1. How to write a proposal letter to a company.
2. What would be our commission from that company.
3. What strategy should I maintain from the beginning to the end of a recruitment process?
4. Where can I find a larger number of CVs?
Thank you for your assistance.
Best regards,
Sumitra Sahu
From India, Calcutta
Acknowledge(0)Amend(0)
I am Sumitra Sahu and have started my recruitment consultant business in Cuttack, Odisha. As I am new in this sector, I need your help with the following:
1. How to write a proposal letter to a company.
2. What would be our commission from that company.
3. What strategy should I maintain from the beginning to the end of a recruitment process?
4. Where can I find a larger number of CVs?
Thank you for your assistance.
Best regards,
Sumitra Sahu
From India, Calcutta
Acknowledge(0)Amend(0)
Hi Sumitra!!!! This is manmeet here, can u just give me your personal email id. Regards Manmeet Executive - HR 9657721121
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Dear Viral Shah,
The sheet attached by you is excellent. However, when I enter data in the first sheet, it does not get updated in the next sheet. Perhaps the link is missing. Please check and revert.
M.V. KANNAN
From India, Madras
Acknowledge(0)Amend(0)
The sheet attached by you is excellent. However, when I enter data in the first sheet, it does not get updated in the next sheet. Perhaps the link is missing. Please check and revert.
M.V. KANNAN
From India, Madras
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Viral,
When I try to enter data in the first sheet, it won't reflect on the other sheet. What are the working hours in the timesheet? Because on that sheet, when I put data (In & Out), the overtime/lacking cell is empty when it should mention 1 hour or 2 hours, depending upon the out time. Kindly help me with this as it is very useful for me.
Thanks,
Maninder
From India, Pune
Acknowledge(0)Amend(0)
When I try to enter data in the first sheet, it won't reflect on the other sheet. What are the working hours in the timesheet? Because on that sheet, when I put data (In & Out), the overtime/lacking cell is empty when it should mention 1 hour or 2 hours, depending upon the out time. Kindly help me with this as it is very useful for me.
Thanks,
Maninder
From India, Pune
Acknowledge(0)Amend(0)
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 the date in the first sheet, month-wise. Please guide.
Regards,
Damyanti
From India, Mumbai
Acknowledge(0)Amend(0)
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 the date in the first sheet, month-wise. Please guide.
Regards,
Damyanti
From India, Mumbai
Acknowledge(0)Amend(0)
Dear All,
Thank you for your valuable suggestions. I have uploaded the sheet with some improvements. It will automatically calculate the overtime if it exceeds 8 hours and will also be updated in another sheet for the monthly overtime of employees. Please download the sheet once again!
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
Thank you for your valuable suggestions. I have uploaded the sheet with some improvements. It will automatically calculate the overtime if it exceeds 8 hours and will also be updated in another sheet for the monthly overtime of employees. Please download the sheet once again!
Thank you.
From India, Pune
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Employee excel sheet.xls