I have several columns to calculate the difference between estimated time and actual time (which is the sum of several columns).
E= Estimated time
F= Actual time (sum of P thru W)
G= Variance (plus or minus minutes and seconds)
This is the formula as it is now:
When the actual time in cell F equals zero, it posts no result. I would like it to post a negative result: I.E. If the actual time equals zero, and the estimated time was :32, I would like the result " -:32" (negative 32 seconds) to be the result in G.
E F G P Q R S... W
Est. Act. Var. Timings
:15 :17 :02 :10 :05 :02 (Actual is greater than estimate, result is +)
:10 :10 0 :05 :05 (Actual equals estimate, result is 0)
:20 :12 -:08 :05 :03 :04 (Actual is less than estimate, result is -)
:32 0 -:32 0 (ACTUAL EQUALS ZERO, RESULT IS NEGATIVE)