payroll calculations

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

I do payroll where I list hours per day I need a formula that when the hours
go over 40 that it will put 40 in one cell and the ammout of overtime in a
cell below it.

Also a formula that will look at other cells such as sick and vacation to be
part of the 40 hour week equation
 
You could use this for the hours up to 40...

=MIN(40,A1)

and this for the excess...

=IF(A1>40,A1-40,"")

Rick
 

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

Calculating regular time, subtracting any personal time 5
Payroll lookup 1
Excel if Functions 1
need help with a payroll formula 1
Trying to calculate hours worked on timecard using "IF" command 6
Payroll Calculations 3
Payroll verification hrs and time off 6
if then formula for total time ;overtime hours versus regular 1

Back
Top