Payroll analysis

  • Thread starter Thread starter Dillion23
  • Start date Start date
D

Dillion23

Im trying to take a column of hours and figure the total net pay for
week, the problem is I need to seperate straight time from overtime. S
say I have 54 hours I need to figure 40hrs @8.50 an hour and 14hr
@12.75 an hour. What type of formula can I use to accomplish this
 
If hours worked are in A1
and Rate is in B1 then:
C1: =MIN(A1,40)*B1+MAX(A1-40,0)*1.5*B1


Does that help?

Regards,
Ron
 
Use IF formula for your calculation. For example if time is in cell A1, use
formula:

=IF(A1<=40, A1*8.5, 40*8.5+(A1-40)*12.75)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

payroll calculations 1
Excel if Functions 1
if then formula for total time ;overtime hours versus regular 1
Payroll calculations for real time 2
Timecard functions and formulas 1
Formula to sum based on a change in another column 2
Payroll lookup 1
excel: How do I setup a function to put any numbers over 80 into . 2

Back
Top