Extract Certain Data Based On Criteria

I have a raw database that contains various data all in one column and I only want to extract certain data to a new column. All I want is to extract the time, like 14:00, 14:15, 14:30, etc...... from column "A" and populate column "D" if it meets this criteria.

I have tried everything I can think of, very difficult yet it seems to be so simple.

The "date" is really a date format but the "time" is really text.

Here is what the data looks like:

Column A has....

Name1:
Name2:
Name3:
10/16/2006
14:00
14:15
14:30
14:45
15:00
10/27/2006
16:30
16:45
17:00