If total hours worked is in cell A1 and normal working week is 40 hours then
if OT is in Cell B1

=MAX(0,A1-40)

or

=IF(A140,A1-40,0)

If OT is paid at 1.5 times standard hourly rate, then OT pay

=B1*C1*1.5 where C1 is standard hourly rate

i.e =Max(0,A1-40)*C1*1.5

To make your s/sheet (more) flexible put the standard hours and overtime
rate/factor in cells rather than have them as constants in the formulae;
pPerhaps also have them as named ranges to make the formulae more readable.

e.g.

=MAX(0,A1-StdHours)*HourlyRate*OTRate

HTH

"rooney2oons" wrote:


I am trying to create a spread sheet that will automatically tell me
what my check should be before all the taxes and stuff are taken out.
I have a cell that shows how many hours I worked in the week. I know
how to calculate my hours times my wage. I need to figure in OT. Any
ideas on this?
If not I will just do it the old fashioned way.

John


--
rooney2oons
------------------------------------------------------------------------
rooney2oons's Profile: http://www.excelforum.com/member.php...o&userid=37750
View this thread: http://www.excelforum.com/showthread...hreadid=573347