How to convert from general to date format in this strange case?

[matt_dynasty]

Hello kind souls,

I am using Microsoft Excel 2013 and may i ask how do i

1) filter the day, month, and time from this format?
 

2) convert the general format to date format? 

I have tried clicking the date format from the General dropbox but it doesn't work. 

The link to this data is located here: http://bit.ly/2cgMGDm

Please Help! Thank you!

[#2]

Matt,

I tried to import the file with Power Query and it - almost - got it right. I only had to adjust the data type to "Date/Time/Timezone".

[#3]

Hi Matt,

Put this formula in cell C2:

DATEVALUE(SUBSTITUTE(REPLACE(B2,1,SEARCH(",",B2),""),"-0000",""))