|This is not the most elegant of ways, but it gets the job done.|
You will need to do Three separate steps.
With your data in cell A1
In cell B1 enter the formula: =FIND("2013",$A$1,1)
In cell C1 enter the formula: =FIND("2013",$A$1,B$1+1)
Drag cell C1 across to Column I, that is were your dates end.
These formulas get the starting location of each of the Date year in cell A1
Now that we have the starting locations of each of the dates:
In cell B2 enter the formula: =MID($A$1,B$1-6,19)
Drag cell B2 across the Column I,
this cuts out the date & times from A1
you should now have all your Dates and Times in their own cells,
but your not finished, as the data is still in TEXT format.
To get Real Dates and Times
In cell B3 enter the formula:
You should now have Real dates and times and you can now do your computations.
Quick and Dirty, but it works.
Edit: Changed last formula.
message edited by mmcconaghy