Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Apr 01, 2023

Eliminate #Value in Time Diff Calculation

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.

 

Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 01, 2023

    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

Resources