Remove time from cells only if the time is 0:00-CodePudding

I have thousands of cells with date and time as follows:

10/22 0:00
10/22 0:00
10/22 6:00
10/22 7:00
10/22 7:00
10/22 12:30
10/23 0:00
10/25 0:00
10/25 0:00

However, I want to make it so if the time is 0:00, it's replaced by just date only, like this:

10/22
10/22
10/22 6:00
10/22 7:00
10/22 7:00
10/22 12:30
10/23
10/25
10/25

Is this possible? Thank you! Looked through all the date and time formats and conditionals and I haven't found anything.

CodePudding user response：

try:

=INDEX(IFERROR(1/(1/B1:B)))