payroll calculations

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
 
R

Rick Rothstein \(MVP - VB\)

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

Top