When I do Text to Columns the date works but the time shows as 1/0/00. I have that column formatted as time, but it gives me a date type response. Here are a few actual cells with data.

Original Converted Date Time Text
1/29/2016 15:26 PHONE 1/29/2016 1/0/00 PHONE
2/14/2016 18:58 PHONE 2/14/2016 1/0/00 PHONE
5/28/2016 19:13 PHONE 5/28/2016 1/0/00 PHONE
7/8/2016 17:16 PHONE 7/8/2016 1/0/00 PHONE
9/1/2016 13:16 PHONE 9/1/2016 1/0/00 PHONE
8/16/2016 11:33 PHONE 8/16/2016 1/0/00 PHONE