need a formula to compute payroll for regular hrs plus OT

NYcowgirl

New Member
Joined
Dec 6, 2005
Messages
31
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.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
If the total hours worked column is in Column D, starting in D2, then the formula is

=MIN(D2,40)*RATE + MAX((D2-40),0)*RATE

Where rate is a cell reference to the pay rate, or a named range.

Copy down

lenze
 

Watch MrExcel Video

Forum statistics

Threads
1,123,351
Messages
5,601,130
Members
414,429
Latest member
Bilaal xaka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top