Converting Date Text String into Date

[djayhawk]

Hi,

I'm trying to find the difference between two dates however the dates the I currently have are text strings. I have about 25,000 rows so wondering if theres a way to convert this into a date I can manipulate. Also, I'd to make the dates PST. This is how it looks exactly in my spreadsheet.

12/1/2013 1:11:08 AM CST

<tbody> </tbody><colgroup><col></colgroup>

<tbody>
</tbody><colgroup><col></colgroup>

 

[AhoyNC]

Try.
The -(1/12) subtracts two hours off the CST time to convert it to PST.

Excel Workbook
	A	B
1	12/1/2013 1:11:08 AM CST	11/30/13 11:11 PM
Sheet

 

[djayhawk]

Thank you, this works!