Conditional Function
 

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

Conditional Function
 

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

On Sep 3, 12:29*am, SluMark wrote:
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

Conditional Function
 

=MAX(B3-8,)


"SluMark" wrote:

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