Extracting Hour from M/D/Y hh:mm

I import a data file from another program with the date and time in the format M/DD/YYYY hh:mm. I need to extract the Hour from that field. The Hour function has worked on this type of data previously (from the same source). Now using =Hour(cell) returns 1/0/1900 0:00.

Attached is a sample portion of the file.

Your assistance would be appreciated.

Try...

=MOD(A5,1)

and format as time