cal. pay with overtime

  • Thread starter Thread starter fountaink
  • Start date Start date
F

fountaink

collum B rate of pay, Collum C numbers of hours worked in one week,
can't get a formula to work in collum D, that will figur the whole pay
Not all weeks have over time, some weeks have less than 40 hours pe
week. Please hel
 
Assuming a 40 hour work week and overtime rate is 1.5 time regular pay, use:

=IF(C2<=40,C2*B2,40*B2)+IF(C2>40,(C2-40)*B2*1.5,0)

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
 
Hi
not quite sure what you're problem is.
If your value in col. C is stored as number use
=C1*B1
in column D

if it's stored as time use
=C1*24*B1

Not sure how you want to calculate overtime?
 
Back
Top