Can somebody help me add a 2nd OR function to this formula so that if a cell = “X” or “-“ it fills the cell with “0h”
iPad Pro, iPadOS 18
The problem is with cell C4. The same checks you are doing for B4 need to be done for C4. Put another comma in the OR function and add a check for C4 being blank then another comma and check for C4 being ="X".
Like this, except you'll havethe table name as part of each reference.
=IF(OR(B4="", B4="X", C4="", C4="X"),DURATION(0),C4−B4)
"0h" in your formula is a string, not a duration. DURATION(0) makes a duration of 0. You will have to format the cell so that hours is the top unit or it will show up as 0w instead of 0h.