Timesheet / Overtime rate calculation

Column 1 Column 2 column 3
Hours worked Rate of pay Total pay
45 15 ???

Need a formula in column 3
If hours worked is over 40, then the 1st 40 hrs is at regular rate and amount over 40 is paid at time and half

There are a number of ways to do this. Here's one way;

Please Login or Register  to view this content.

Assuming your hours are in A1 and rate of pay in B1

ChemistB

that did the trick. Now if I only understood what I just did!

Here's a breakdown of the formula

Please Login or Register  to view this content.

First, A1 * B1, total hours * base pay (the easy part)

Second, determine if it's over 40 hours and if so, by how much

Please Login or Register  to view this content.

Takes the maximum of either Total hours - 40 or zero. SO if A1 is less than 40, A1-40 is negative and Excel chooses "0." If it's greater than 40, then it tells you how much (A1-40)

and (thirdly) takes that number and multiplies it by half (B1/2) their pay scale for time and a half.

ChemistB