I have h:mm in a cell,

[excel on the run]

However when its 0:00 I'd like the cell to be empty. Hope u can help out.
Thanx Brian

 

[Rick Rothstein]

However when its 0:00 I'd like the cell to be empty. Hope u can help out.
Thanx Brian

If you individually select a sampling of your cells displaying 0:00, does the Formula Bar show "12:00:00 AM" or something else for them? If something else, what?

 

[excel on the run]

They all show a formula, because there is a formula to get the times for these cells.

 

[shg]

Format as h:mm;;

 

[excel on the run]

Thanx, worked great....