Conditional Function

[SluMark]

I am trying to calculate overtime hours, but I do not know how to program it.

Something like: IF B3 <= 8, then C3=0 If B3 >8, then C3 = Amount Greater
Than 8

 

[Pete_UK]

Assuming you have decimal hours in those cells (rather than Excel time
formats), try this:

=MAX(0,B3-8)

i.e. if B3 is less than 8 then B3-8 will be less than 0, so the MAX
function will choose 0, but if B3 is greater than 8 then B3-8 will be
greater than 0, so that will be returned instead.

Hope this helps.

Pete

 

[Teethless mama]

=MAX(B3-8,)