I have a formula in my cell that is set up in time 13:30 to be displayed. When I have no values in the two time cells it is adding the cell is displaying 0:00. How can I add to my formula to show a blank cell instead. My formula in the cell is =IF(C5<2359,D5+24C5,D5C5).
Show blank cell



Hi Anonymous:
Try this, on the toolbar select tools  options  view and then deselect zero values. I hope this helps.
Chris

Thanks for the help. I did try that and it is not working. I have to use the military time and in my formula it changes to 24 when I deselect the zero value. I am lost....

Try this code please.
=IF(AND(C5="",D5=""),"",IF(C5<2359,D5+24C5,D5C5))
Thanks,
Rennie 
Thanks Rennie. That has worked. I have found a great deal of info on this site. I hope it keeps going. Thanks again...

Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!