G Guest Jul 16, 2007 #1 In a cell that already has an IF formula in it, how do I hide any negative answer so as to show 0:00 (time) or at least blank?
In a cell that already has an IF formula in it, how do I hide any negative answer so as to show 0:00 (time) or at least blank?
B Bob Phillips Jul 16, 2007 #3 Format the cell as hh:mm; -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Format the cell as hh:mm; -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
