AnsweredAssumed Answered

Equation help

Question asked by TraceyAkin on Apr 11, 2012
Latest reply on Apr 12, 2012 by Dillik


Equation help


In short, I have an equation (below) which subtacts the start time from the finish time, giving me an elapsed time.  I have an IF in the equation which will result in a blank result if there is no finish time to work with.  Instead of a blank, I would like to have the option of putting a DNF (did not finish), DNS (did not start/show) or DQ (disqualified) in the cell.  Is there a way to do such a thing?

Thanks for any help or suggestions.


If ( Finish Time ≠ 0 ; If ( Finish Time  =  0 ; Start Time ; Finish Time - Start Time + Penalty Time) ; "" )