I am trying to subtract time values but only if the original cell is not 0.
L15 is a static value of 6:30 (6 hours and 30 min). I am subtracting cell G12 but only want the calculation if G12 is not 0:00.
I currently have this =IF(G6<>”0″,L15-G6) but it returns the result of 6:30 because it is subtracting 0 from it still. I dont think I can use ifblank because they are time cells with 0:00 value?