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



[TABLE="width: 113"]
<tbody>[TR]
[TD][TABLE="width: 173"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[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!