I need help writing an "IF" function

[djgrimaldi]

I am trying to write a formula to input into cell R18, R19, etc.. to accomplish the following:
The function I have inserted (=IF(J18=12,M18-G18,IF(J18=13,M18-G18,2)) almost works but I am hitting a snag. Here is what I need to accomplish. Time is being entered as 100th's, not minutes.



#1 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is greater than G34, then R34 should dispaly the number "2" (representing 2 hours).

#2 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is equal or less than cell G34, then R34 should dispaly the number as a "0".

#3 - If the number "12" or "13" is input into cell "J18, J19 etc.." then M34 should dislay the result of M34 minus G34. Any negative number should display as a Zero.

"G""J""M""R"Layover StartDriver Hour ClassStart TimeLoad ReadyTime Paid19.021419.022.0019.021421.352.0019.021319.150.0219.021218.590.0019.021220.000.96

[xor]

If I have understood you correct.

[djgrimaldi]

In response to your question about not understanding the text you highlighted in RED.

My apologies as I shortened the original spreadsheet before I posted it and did not change the cell reference numbers from M34 to M18, etc.. to correspond with the shortened sheet.

I reviewed the document you sent and it does exactly what I was looking for!

Thank you for your help and for being an expert at Excel. You have now made my life much easier