need a formula to compute payroll for regular hours 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

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
Joined
Feb 10, 2002
Messages
1,611
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,089
Messages
5,570,152
Members
412,306
Latest member
fabio6
Top