help PLEASE with a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bana - 04 Oct 2004 19:25 GMT

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!

Reply to this Message

wally - 04 Oct 2004 19:54 GMT

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

>-----Original Message-----
>I'm sure this is simple, but it's driving me crazy. I have a column of HOURS
[quoted text clipped - 3 lines]
>Thanks!
>.

Reply to this Message

firefytr - 05 Oct 2004 16:42 GMT

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

--
firefyt

Reply to this Message