I can say it out loud but am struggling to get Excel to do it. I need this result in column D...
If B<A AND C>5 min, then C. If B>A AND C>7 min, then C. Otherwise, blank.
If the formatting was a number, my formula works. But when I change it to time it does not. And, I can only seem to get one half of the formula at a time. So I need help nesting them together as well as time time value comparison.
Here's what I have so far... =IF(AND(B5<A5,C5>5),C5,"")