Converting a text string to a date

Hi,

I have a text string which is "Apr 13, 2016 11:22 AM". How do I convert this to a date format which can be used in further calculations (for example finding the difference between two dates)?

I've tried DATEVALUE which returns error. I don't want to edit my data source by using text to column function either..

Try:

=A1+0

Or:

=--LEFT(A1,12)

LEFT separates my date but I want to convert the 'Apr 13, 2016' to '13-04-16'

Format Cells -> Custom -> dd-mm-yy

This problem is solved thanks