If condition

[ganeshkumar]

hi, i need if condition to solve my problem,conditions are,

if delay time is< 2hrs answer should be "CE NO" otherwise "CE YES",
and next condition is if delay is equal to zero answer should be "CRA NO" otherwise "CRA YES"

formate is here
Delay
1:59:00
0:00:00
0:00:00
0:00:00
19:17:00
16:13:00
0:00:00
14:46:00
2:41:00

[alansidman]

Here is a link on nested if statements.

http://www.techonthenet.com/excel/fo.../if_nested.php