if and then

[lhernandez0620]

I'm trying to do a formula that says if column b17 is over 8, then subtract the overage and put it in this column.  I've only figured out how to put the overage in this column but not subtract it from the original column.

[#2]

@lhernandez0620 

Where are here B17, this column and original column?

[#3]

@Sergei Baklan b17 is where the 9 is and the 1 is the column i'm doing the formula.  

So this is a timesheet and i;m trying to move the overtime to the next column.

[#4]

@lhernandez0620 

Where 1 it could be

=B17 - 8*(B17>8)