help PLEASE with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm sure this is simple, but it's driving me crazy. I have a column of HOURS
WORKED and a column of HOURLY RATES. I need a formula for the GROSS WAGES
column that goes as follows: gross wages are hours worked x rate with time
and a half for hours over 40.
Thanks!
 
A simple IF() statement can do this
Let's say that cell A1 holds hours worked and A2 hold rate
of pay

Use a formula something like this
=IF(A1>40,(40*A2)+(A1-40)*(A2*1.5),A1*A2)
Hope this helps
Wally
 
Results may also be skewed if you have your formatting not entered a
time, or vice versa. Just keep in mind that time values, as seen b
Excel, are only portions of a whole number; one day is one whol
integer (number), so 12 hours would be 0.5
 
Back
Top