The fact that splitting this into columns isnt working for this particular time stamp is the problem. I've tried doing using that capability in many ways and none will quite do the job. Problem arises because I have to split on a space delimiter (can't do fixed widths).

Basically I need a way to convert a text date to a number.