Employee Over Time Calculator is a ready-to-use calculator that helps you to calculate overtime of employees in a small or medium-sized organization.
Over Time Pay means the amount compensated for hours or days worked more than the maximum limit mentioned in your contract or set by federal/provincial law.
Usually, small companies and factories require managing the employee hours for the payment of overtime. It sometimes becomes a tedious job.
Employee Over Time Calculator Excel Template
We have created an Over Time Calculator Excel template with predefined formulas. You can easily and efficiently calculate overtime. Just enter the In and Out time along with the overtime rate and it will automatically calculate everything for you.
Click here to Download Employee Overtime Calculator Excel Template.
Click here to Download All HR & Payroll Excel Templates for Rs 199.
You can download the same in Apple Numbers from the below link:
Overtime Calculator Apple Numbers Template
Additionally, you can download other HR Templates like Salary Sheet, Attendance Register, Gratuity Calculator, etc.
Let us discuss the contents of the template in detail.
Contents of the Employee Overtime Calculator Template
This template consist of 3 sections
- Header Section.
- Summary Section.
- Data Input Section.
1. Header Section
The header section consists of the company name, company logo and heading of the sheet “Employee Overtime Calculator”.
2. Summary Section
The summary section consists of the following subheadings:
Employee Name: Name of Employee.
Month: Select the month from the drop-down list.
Click on the link below to learn how to easily create a drop-down list.
How to create a drop-down list in 3 easy steps.
Year: Enter year.
Hours: This cell will display the total number of hours worked by the employee for the whole month.
Rate/Hr: Enter the rate per hour for overtime.
Total OT: Total OT shows the total amount of Overtime earned by the employee.
3. Data Input Section
Data Input section consists of the following subheadings:
Date: Date from 1st of every month till the end is displayed here.
In: Employee In time is entered here.
Out: Employee Out time is entered here.
Overtime: The template automatically calculates the number of hours worked more than the limit.
The formula applied here is =IF(OR(D11=””,F11=””),””,(IF(D11>”12:00″,”00:00″,(“24:00”-D11)+F11))-“08:00”)
We have set the limit to 8 hours. You can change it by changing the last part of the formula.
Rate: Rate per hour of Overtime.
Amount: The total amount of overtime per day is displayed.
In the end, totals of monthly overtime hours and amounts are displayed.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Thank You so much . infact your efforts are priceless. Its made my work so easy and many many thanks.
Happy to know that it helped you. We also have many other such templates in our HR Templates category. Apart from that, there are many accountings Templates as well as financial analysis templates which can be helpful to you as well as your colleagues. Please share the links with your friends and colleagues and also on different social media. Thank you for appreciating our efforts. This encourages us to do more.
Hi I am a small works shop owner where in we have 8 workers and 1 supervisor
I have put the attendance machine which gives excel output of the attendance
The workers are on daily wedge basis and supervisors on monthly wedge system.
We dont have seperate account hr etc department I only handle the things
Is it possible to that the data through the attendance machine is directly coupled to the salary calculator
If not do you have some template where in by feeding the data from the excel the salary is calculated and the salary slip is generated
We have only basic pay and dont give any allowance except for overtime and bonus for the workers as the works doesn’t fit in to PF bracket we have deduction only against advance
Thanking you in advance Sanjeev
Hi Sanjeev. I have understood your point. You will need to customize the sheet merging with salary. It will be a tough job for you. Contact +91 9687858563 for customizing your sheet as per your requirement. Thanks and Regards
how to calculate overtime?
Overtime is calculated In time minus out time where the shift hours are predefined to 8 hours.
I work 13 hours everyday as a clearner insteady of 8 hours meanwhile i have worked there a year and three weeks how much suppose to be my over time money, although my salary is 1200 aed
Insert your hours of work in-time, out-time and overtime rate for the complete time period in the calculator to know the exact amount of your overtime.
Hi,
Can you help me to calculate overtime in excel with two rate. The example as below:
start End Rate
22:00 6:00 1.25
6:00 8:00 1.125
17:00 22:00 1.125
In Out Rate 1.125 Rate 1.25 Total ($8.89/hours)
5.00am 8.00am 2 hours 1 hours $31.11
How i want to excel automatic calculate hours in column rate.
Thanks for your help.
I cannot understand your query, Aida. Can you please simplify it.
DEAR SIR
KINDLY TEL ME THE WHAT IS THE CALCULATION OF EPF & ESI ON OVERTIME PAYMENTS FOR SALARY AND WAGES.
THANKING YOU
EPF and ESI is calculated on your salary and not overtime.
THANK YOU, SIR BUT SOME PERSONS SAYING ESI CALCULATED ON OVERTIME, KINDLY CLEAR MY CONFUSION.
THANKING YOU.
Employees’ State Insurance is a self-financing social security and health insurance scheme for Indian workers. For all employees earning Rs. 15000 or less per month as wages, the employer contributes 4.75 % and employee contributes 1.75 %, i.e., total share 6.5 %. ESIC is calculated on gross salary (excluding washing allowance). Employees drawing gross salary above Rs. 15000 will not be applicable under ESIC.
HOW TO CHANGE PREDEFINED 8 HOUR SHIFT TO 10 HOUR SHIFT.
Change the formula in overtime column to this =IF(OR(D11=” ”, F11=” ”),” ”,(IF(D11>”12:00″,”00:00″,(“24:00”-D11)+F11))-“10:00”)