Returning Zeros as blanks but not at Midnight!

[m1cks]

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

[Pepe Le Mokko]

00:00 is only how XL displays midnight it is not really zero
You could try =IF(your_formula=0,"",your_formula) to get rid of the 0's
Be aware that if you need these values in another formula the "" is a text string...

[m1cks]

Thank you. This has solved my issue

[Pepe Le Mokko]

Most welcome