Time Card Calculator with Overtime

Overtime rule

Weekly OT after (hours)

Hourly rate

Overtime multiplier 1.5 is time-and-a-half.

Day	Hours
Mon
Tue
Wed
Thu
Fri
Sat
Sun

This is a spreadsheet model of one daily rule or one weekly rule, not legal advice. Overtime laws vary by place, and some employers must apply both. Numbers stay in your browser. The default week is 8, 8, 8, 8, 10 hours at $20 with time-and-a-half after 40, which pays $860.

Quick answer: for a weekly threshold of 40 hours, with daily totals in B2:B8 and a rate in D2:

=MIN(40, SUM(B2:B8))*D2 + MAX(0, SUM(B2:B8)-40)*D2*1.5

For a daily threshold of 8 hours, compute regular and overtime on each row, then add the pay. Clock-in and clock-out times belong in the hours worked calculator first; this page starts from hours already totaled for each day.

A 42-hour week at $20

Suppose the card reads 8, 8, 8, 8 and 10 hours, with two days off. The week totals 42. Under a 40-hour weekly rule, regular hours are 40 and overtime is 2. At $20 and a 1.5 multiplier, regular pay is $800, overtime is $60, and the total is $860. In Google Sheets on 12 November 2026:

=MIN(40, SUM(8,8,8,8,10))
=MAX(0, SUM(8,8,8,8,10)-40)
=MIN(40, SUM(8,8,8,8,10))*20 + MAX(0, SUM(8,8,8,8,10)-40)*20*1.5

returned 40, 2, and 860. A daily 8-hour rule on the same card also yields 2 overtime hours, because only Friday (10) goes past 8, and by 2 hours. The rules do not always agree, which is the next example.

When daily and weekly rules disagree

Take four days of 10, 10, 10 and 6 hours — 36 hours for the week, under a 40-hour weekly cap. Weekly overtime is 0, and all 36 hours are regular. Daily overtime of 8 hours is different: each 10-hour day contributes 2 overtime hours, and the 6-hour day contributes none, so overtime is 6 and regular is 30. In the same Sheets check:

=MAX(0,10-8)+MAX(0,10-8)+MAX(0,10-8)+MAX(0,6-8)
=MIN(8,10)+MIN(8,10)+MIN(8,10)+MIN(8,6)

returned 6 and 30. If your policy (or your jurisdiction) uses daily overtime, do not use the week-total formula, or you will under-count those six hours.

Five 9-hour days are 45 hours. A daily 8-hour rule gives 5 overtime hours and 40 regular hours, which happens to match a 40-hour weekly rule as well. That is a coincidence of the numbers, not a reason to treat the two formulas as the same.

Optional double time on a daily card

Some daily rules pay time-and-a-half after 8 hours and double time after 12. For a 13-hour day, that is 8 regular, 4 overtime, and 1 double-time hour. The Sheets check used:

=MAX(0, MIN(13,12)-8)
=MAX(0, 13-12)

which returned 4 and 1. At $20, 1.5× and 2×, that day is 8×20 + 4×30 + 1×40 = $280. Leave the double-time box blank if you do not use a second daily threshold. This calculator does not apply double time under the weekly rule.

What this will not decide for you

Whether overtime is daily, weekly, or both, whether the seventh day is special, and whether a bonus or a salary changes the regular rate are questions for the actual rule that applies to the job. The formulas above implement one threshold at a time, with a regular rate you type in. They do not include unpaid breaks (subtract those before you enter the hours), shift differentials, or a workweek that starts on Wednesday.

Empty days are treated as 0. Hours must be decimal hours (8.5, not 8:30). If you have times rather than hours, convert them first so an overnight shift is not entered as a negative.

Questions that come up

How do I calculate weekly overtime in Excel or Google Sheets?

If daily hours are in B2:B8 and the weekly threshold is 40, regular hours are =MIN(40,SUM(B2:B8)) and overtime hours are =MAX(0,SUM(B2:B8)-40). Multiply regular hours by the hourly rate and overtime hours by the rate times the overtime multiplier (1.5 for time-and-a-half).

What is the difference between daily and weekly overtime?

Weekly overtime looks only at the week total: hours past 40 (or another threshold) are overtime, even if no single day went long. Daily overtime looks at each day: hours past 8 (or another threshold) that day are overtime, even if the week stays under 40. The two rules can disagree on the same time card.

Can I enter clock-in and clock-out times here?

This calculator starts from hours already totaled for each day. Use the hours worked calculator first if you have clock times, including overnight shifts and unpaid breaks, then paste the decimal hours into this page.