I am using SAP Crystal Reports Version 2011

I am using SAP Crystal Reports Version 2011 to run data reports from another database. The problem I have is all data TIME fields are recorded as TEXT fields. Crystal will not summarise the text fields, I need the summery to be in time not text, is there a way to convert the TEXT data in to TIME in the report. I have tried to export the data to excel then convert the TEXT to TIME however it is not straight forward, and I need the report to host the data in TIME format.