Good rainy afternoon. Perfect time for doing computer stuff. 
I export, in to excel, reports from a database.
In one of my columns, (start time), the cell value displays as 0001
However, what shows in the formula bar, for that same cell, is: 7/12/2019 12:01:00 AM
How do I get rid of the date and have both the cell value and the formula bar display the time as 0001?
I guess, I need it to get rid of the date and then convert to 24 hour time because I need to be able to make 'greater than' and 'less than' comparisons.
Also, when I convert to 24 hour time, I don't want the ":" in it. I just want it to be something like: 1330, 1420, 0900.
I have tried to change it myself, but none of the things I've tried get me to a time without the : in it.
-Christine

I export, in to excel, reports from a database.
In one of my columns, (start time), the cell value displays as 0001
However, what shows in the formula bar, for that same cell, is: 7/12/2019 12:01:00 AM
How do I get rid of the date and have both the cell value and the formula bar display the time as 0001?
I guess, I need it to get rid of the date and then convert to 24 hour time because I need to be able to make 'greater than' and 'less than' comparisons.
Also, when I convert to 24 hour time, I don't want the ":" in it. I just want it to be something like: 1330, 1420, 0900.
I have tried to change it myself, but none of the things I've tried get me to a time without the : in it.
-Christine