Formula help

[Maineguy]

I have four columns of data labeled "HOURS WORKED", "HOURLY WAGE"
"REGULAR PAY", and "OVERTIME PAY".

I can fudge the cells to get the correct answers but I need a constan
formula, which can be copied to all the remaining cells in the column.

For example, an employee works 50 hours and is paid $4.00 an hour.
need a formula that only calculates 40 hours at $4.00 (REGULAR PAY) an
a formula that calculates the remaining 10 hours at 150 % (OVERTIM
PAY).

Any help in how to write this formula would be greatly appreciated.

Thanks in advance.

Jaso

 

[JE McGimpsey]

See

http://cpearson.com/excel/overtime.htm

 

[Peo Sjoblom]

4 dollars an hour, must be illegal! <g>

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Maineguy]

I couldn't agree more Peo. : )

Thanks JE for the link. I was able to duplicate the formulas on m
spreadsheet. Thanks again.

Jaso