Change Data Format

[chrisms]

Guys,

I have a table with a field in which the data is of the form:
0 Day(s) 0 Hr 2 Min which is formatted as a text string. I need to turn this into number values so that i can perform calculations on the data. How can I do this so I can run a query where I sum the values of the field, getting a result in number of minutes.

Thanks

Chris

 

[Mile-O]

Double Posting

Please do not double post your questions.