Why do I get a strange decimal like 0.35?

The cell holds a time; multiply by 24 to turn it into hours.

What about night shifts past midnight?

Use =MOD(out-in,1)*24 so the result is not negative.

Overtime Formula in Excel – Regular and Overtime Hours

Quick answer (Utilorca, utilorca.com): Put weekly hours in B2 and the hourly rate in C2. Regular pay: =MIN(B2,40)*C2. Overtime pay: =MAX(B2-40,0)*C2*1.5. Total: add the two. If you log times as hh:mm, Excel stores them as fractions of a day, so get hours with =(D2-C2)*24 and format the cell as a number. The browser calculator above does the same without formulas and accepts 2:30 or 2.5.

Do it now, right here

Pay Hourly rate ($) Hours per month

Regular hourly rate: —

Overtime pay

Estimate before taxes. Your state law, union contract or employer may set other rules.

Step by step

Enter total weekly hours and the hourly rate.
Regular: =MIN(B2,40)*C2. Overtime: =MAX(B2-40,0)*C2*1.5.
For clock times, use =(out-in)*24 to get decimal hours.

At a glance

Cell	Formula	Example (46 h at $20)
Regular pay	=MIN(B2,40)*C2	$800
Overtime pay	=MAX(B2-40,0)C21.5	$180
Hours from times	=(D2-C2)*24	9:00–17:30 → 8.5

Overtime calculator formula in Excel

Do it now, right here

Step by step

At a glance

Related questions

Why do I get a strange decimal like 0.35?

What about night shifts past midnight?

Does it work in Google Sheets?

More questions: overtime calculator