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) ; "" )