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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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,118,730
Messages
5,573,870
Members
412,555
Latest member
mark84
Top