I have a time sheet where I have a cell that finds the difference of the end time and the start time. If the times are zero, the difference cell is filled with “#VALUE!”. FWIW, the format of the difference cell is ‘[H]“h” MM"m"’, but this is not the cause of the error. How can I insert a formula, say using IIF, that would blank the cell or insert a zero if the difference is zero. I’m also trying to mitigate the issue of the sum of these cells not working if any of them contain this error, so blanking them or inserting a 0 would solve that problem.