Conditional formating dates

[JimO]

I have a list of dates and times, the value is set up as Date/Time. I want to display them in seperate columns one formated as date and the other as time. The issue I am having is that not all values have a 'valad' time and shoe up as a default value "12:00 AM". Is there a good way to hide only the default values?
I have been unable to come up with any solution using conditional formating to blank out unwanted values (default).



Any ideas?
Thanks, Jim O

[June7]

Why would date/time not have a valid time? How were date/time saved? Midnight (12:00 AM) does not show time parts in unformatted field. Data will never have midnight time?

Consider:

IIf(Hour(x)=0,Null,TimeValue(x))

[JimO]

That works great, thanks.
I put this table together a few years ago ( from an Excel spreadsheet) before I knew enough not to do it the way I did, just trying to correct old errors.

Again thanks for your input on this.
Jim O