MIN
(1)
Ammout
(1)
Week
(1)
Day
(1)

payroll calculations

Asked By Berni
22-Feb-08 02:16 PM
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...

Asked By Rick Rothstein \(MVP - VB\)
22-Feb-08 02:32 PM
You could use this for the hours up to 40...

=MIN(40,A1)

and this for the excess...

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

Rick
Post Question To EggHeadCafe