# need a formula to compute payroll for regular hours plus OT

#### NYcowgirl

##### New Member
I need a formula to compute payroll for regular hours plus overtime.

If I start with 53 hours at \$14.50 per hour, and use a base of 40 hours per week, I need to compute the pay for the 40 hours PLUS the pay for the 13 hours overtime at time and a half.

=(40*14.5)+13*(14.5*1.5)

The formula shown above does the computation manually, but I need a formula that will do it automatically for a large number of employees.

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### Russell Hauf

##### MrExcel MVP
Say you have Salary in column A, and Hours in Column B:

=A5*(B5+(B5>40)*(B5-40)*0.5)

OR, in a more readable way:

=B2*A2+((B2>40)*(B2-40)*A2*0.5)

Hope this helps,
Russell

Replies
7
Views
148
Replies
1
Views
95
Replies
1
Views
209
Replies
10
Views
1K
Replies
1
Views
53