Show blank cell

imported_Anonymous · Feb 20th 2003

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+24-C5,D5-C5).

ChrisBEE1 · Feb 20th 2003

Hi Anonymous:

Try this, on the toolbar select tools - options - view and then deselect zero values. I hope this helps.

Chris

imported_Anonymous · Feb 20th 2003

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....

Rennie · Feb 21st 2003

Try this code please.

=IF(AND(C5="",D5=""),"",IF(C5<2359,D5+24-C5,D5-C5))

Thanks,
Rennie

imported_Anonymous · Feb 21st 2003

Thanks Rennie. That has worked. I have found a great deal of info on this site. I hope it keeps going. Thanks again...

Show blank cell

Participate now!

Share

Users Viewing This Thread