ZorantaGuides
Clocktape

Clocktape › Guides

How to Calculate Overtime Hours from a Time Card

Overtime hours are the hours you worked beyond the threshold that applies to you. Add up the week in hours and minutes, subtract the threshold, then convert the result to decimal hours. With an example threshold of 40 hours, a 44:15 week has 44:15 − 40:00 = 4:15 of overtime, which is 4.25 hours.

The arithmetic is short. What takes care is the threshold itself, which can be weekly, daily or both, and which hours count as worked.

Strips of paper tape where one runs past a pencil line

How to calculate overtime hours, step by step

  1. 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.
  2. Add the days in the workweek in hours and minutes.
  3. 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.
  4. Subtract the threshold from the total. If the answer is zero or negative, there is no overtime that week.
  5. Convert to decimal hours if you will multiply by a rate: minutes ÷ 60.
Clocktape

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.

DayHours workedOver 8:00 that day
Mon9:301:30
Tue8:000:00
Wed10:152:15
Thu7:450:00
Fri8:450:45
Total44:154: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.

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:

ItemCalculationAmount
Regular hours40 × $20$800.00
Overtime hours4.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:

How to calculate overtime hours in Excel

With daily hours as times in B2:B8 and the weekly total in B9:

Test it on the example above: the weekly formula should give 4.25 and the daily ones should add to 4.50.

This page explains the arithmetic only. It is not legal, payroll or tax advice. Overtime thresholds, multipliers and exemptions are set by law and contract and can change; check the official guidance for where you work or ask your employer's payroll team.
Clocktape

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 Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Clocktape.