Eliminate #Value in Time Diff Calculation

Contributor

How can I write the formula to account for blanks in the 'OutTime' column and eliminate the #VALUE! content?

I'd be fine if the formula said - if F2 blank use D2 content in calculation, which would return a 'WaitTime of 0:00:00.

Phishdawg_0-1680378393934.png

 

1 Reply

@Phishdawg 

I'd use

 

=IF(OR(D2="", F2=""), "", F2-D2)

or

=IF(OR(D2="", F2=""), 0, F2-D2)

 

and format the cells with the formula as h:mm:ss