How to calculate overtime hours, step by step
- Work out the hours for each day from start and end times, taking off unpaid breaks. Our guide on how to calculate hours worked covers this.
- Add the days in the workweek in hours and minutes.
- Find your threshold. This comes from the law where you work and your employment contract. In the United States, the Department of Labor's overtime pay page explains the federal rule; some states add their own, including daily limits.
- Subtract the threshold from the total. If the answer is zero or negative, there is no overtime that week.
- Convert to decimal hours if you will multiply by a rate: minutes ÷ 60.
In Clocktape you can tap the week's total and use it in a new line, so "Week − 40:00" shows the hours over your threshold. Get it on Google Play
Overtime hours and minutes: a worked example
All numbers below are examples. The threshold of 40 hours a week and 8 hours a day are used only to show the method.
| Day | Hours worked | Over 8:00 that day |
|---|---|---|
| Mon | 9:30 | 1:30 |
| Tue | 8:00 | 0:00 |
| Wed | 10:15 | 2:15 |
| Thu | 7:45 | 0:00 |
| Fri | 8:45 | 0:45 |
| Total | 44:15 | 4:30 |
Week total: hours 9 + 8 + 10 + 7 + 8 = 42, minutes 30 + 0 + 15 + 45 + 45 = 135, which is 2:15. So the week is 44:15.
- Weekly method: 44:15 − 40:00 = 4:15 = 4.25 hours.
- Daily method: add each day's time over 8:00: 1:30 + 2:15 + 0:45 = 4:30 = 4.50 hours.
The two methods give different answers from the same time card. Where both kinds of rule apply, the law decides how they combine so the same hour is not counted twice. Check the rule for your state or country rather than picking the bigger number.
From overtime hours to overtime pay
Once you have overtime in decimal hours, the pay is overtime hours × hourly rate × the overtime multiplier that applies to you. With an example rate of $20 and a multiplier of 1.5:
| Item | Calculation | Amount |
|---|---|---|
| Regular hours | 40 × $20 | $800.00 |
| Overtime hours | 4.25 × $20 × 1.5 | $127.50 |
| Total for the week | $800.00 + $127.50 | $927.50 |
The minutes mistake
If 4:15 is typed as 4.15 instead of 4.25, overtime pay comes out as 4.15 × $30 = $124.50, three dollars short. It is the same slip that turns 7:45 into 7.45 on a time card. Convert minutes by dividing by 60; our minutes to decimal hours chart has every value.
What counts toward overtime
Overtime is calculated on hours worked, so the same questions as any time card apply. U.S. federal guidance in Fact Sheet #22 on hours worked covers rest breaks, meal periods, on-call time and travel. Things to check on your own card:
- Short paid breaks stay in the total; unpaid meal periods come out.
- Paid time off, such as a holiday you did not work, may not count as hours worked for overtime; this depends on your rules and contract.
- A night shift that crosses into a new workweek may need splitting between the two weeks.
- Not every job is eligible for overtime. Exemptions depend on the work, the pay and the law that covers you.
How to calculate overtime hours in Excel
With daily hours as times in B2:B8 and the weekly total in B9:
- Weekly total:
=SUM(B2:B8), formatted as[h]:mm. - Weekly overtime in decimal hours:
=MAX(0,B9*24-40), replacing 40 with your threshold. - Daily overtime for one row:
=MAX(0,B2*24-8), replacing 8 with your daily limit.
Test it on the example above: the weekly formula should give 4.25 and the daily ones should add to 4.50.
See the hours over your threshold
Add each day on a Clocktape tape and subtract your threshold on the last line; fix any day and the overtime figure follows.
Get it on Google PlayiPhone version coming soon
More guides
- How to Calculate Hours Worked: Start, End, Breaks and Weekly TotalCalculate hours worked from start and end times: subtract, take off unpaid breaks, add the days, then convert to decimal hours. A full worked week included.
- How to Calculate Hours Worked Overnight (Shifts Past Midnight)When a shift ends after midnight, add 24 hours to the end time before subtracting. Night shift examples, breaks, splitting at midnight and spreadsheet formulas.
- Minutes to Decimal Hours: Formula and Conversion ChartConvert minutes to decimal hours by dividing by 60. Full chart from 1 to 60 minutes, the reverse conversion, rounding to 1, 2 or 3 places, and common time card mistakes.
- Adding Hours and Minutes Together (and Subtracting Them)Add hours and minutes by adding each part, then carrying every 60 minutes into an hour. Examples for subtracting, totals over 24 hours, seconds, and multiplying time.
Published by Zoranta, the developer of Clocktape.