Overtime less than contracted hours

**stevehall** · 11-03-2011, 12:01 PM

Hi guys

I am trying to produce a worksheet for hours of work o/t and how much i earn each day
i have done most and working fine except one thing thats bugging me.

cell (i) hours worked
cell (k) contracted hours
cell (m) overtime

what i am looking for is if

cell (i) has 07:00:00 hours worked
but contracted hours is 8hrs then i want
cell (m) to show 00:00:00 as overtime

hope someone can help

cheers

**Fotis1991** · 11-03-2011, 12:41 PM

Hi.

Please take a look at the attached file

Is this what are you looking for?

**aff219** · 11-03-2011, 12:46 PM

put in cell (m) (formatted as time):
=IF((k)>(i),0,(i)-(k))

I used your format of (i), (k), and (m), obviously cahnge those to proper cell targets

what it wll do: if your contracted hours are less than the actual hours worked, it will display 0 overtime in (m), if the hours worked is higher than the contracted hours, it will show the difference of hours worked vs contracted in (m), thus showing the amount of overtime you earned assuming thats how you want it to function.