Hi. I am building a sheet with lots of formulas that return zeros where there is no associated data. I have changed the settings to hide 0 value returns to keep the sheet looking clean. The problem I have is that some of my cells have the time value of midnight, displayed as 00:00. This time is being seen as 0 value and it is hiding the time leaving the cell blank.
Currently to get around this I have had to changed the midnight times to show 00:01 but this is not really the way I want to get around this problem.

Is there anything I can do to hide all of the 0's but when then cell is trying to display the time of 00:00 to allow it?

TIA