Forum Discussion
IF with AND using TIME calculations
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...
One more variant
If to show just number of minutes (Column C)
=MINUTE(ABS(A2-B2))Using it, variance above limits (Column D)
=IF(C2>5+2*(1-SIGN(A2-B2)),C2,"")But perhaps you need to show only variance above limits (Column E, not using columns C and D)
=IF(MINUTE(ABS(A2-B2))>5+2*(1-SIGN(A2-B2)),MINUTE(ABS(A2-B2)),0)This column is formatted to not show zeros, "-" instead.
That's in second sheet attached.