Subtract time if value not 0:00

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?


By: Dan

Leave a Reply

Your email address will not be published. Required fields are marked *