need help with a payroll formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'am just learning to use formulas and working on a payroll spreadsheet. I
have it all done except that overtime is paid after 40 hours. I need a
formula that tells it to take any hours over 40 and put it into the overtime
column. Can you help
 
say hours worked are in cell a1 then to have overtime in cell b1 type the
following:

=max(0,a1-40)
 

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
Payroll lookup 1
Payroll Calculation - Help Needed 3
Please help a rookie! 5
payroll calculation 4

Back
Top