Morning again.
Couple of things first. I strongly suggest you read a little about regular expression and how to use them, then have a play with them. They are very powerful for this type of thing involving a predictable pattern and splitting it up. Try Regular expressions and look at the LabVIEW help for the "match regular expression's".
I would also suggest you would be better working with a 24 hour clock system rather than AM and PM, from past experience I think using AM and PM will lead you to nothing but woe; when you come to get data out of the database and analyse the results things can get messy. Also where are you getting your time from if you are using LabVIEW its self then you would be better using the LabVIEW timestamp type.
Anyway some example below that might help you
cheers
Dannyt