Hi there,



I am having difficulty converting a time text string to a time format. Currently the time stamp is as follows:

2/8/10 11:00:00 AM PST
2/8/10 11:05:00 AM PST

I would like the data to be in two columns, the first a date only

2/8/10

and the second a full timestamp

11:00:00 AM (formatted for time, further functions to be driven off this time)

Problem is I cant make a few things happen: 1) data to columns with a space delimiter is great, but I cannot get the AM back into the formula and get to a correct timestamp.
2) I am unable to us a replace, concatentate, && type formulas it seems, Although promising, I also cant figure out a timevalue, etc type formula.

Let me know if you can think of something to work, happy solving,
Fraser