won't show blank cell
i have entered a formula =H14+G14-I14 in cell J14
I have set the sheet to show 0 as a blank, the cells are formatted to time but if the result in j14 is 0:00 it shows in the cell and is not blank?
the rest of the cells in the sheet will be blank on 0
can someone help?
|