Text to Time Conversion

[PhilH_23]

I have a text string in the following format "00:09:10". Is there a function I could use that would convert it to HH:MM:SS?

I have been asked to calculate an average of time spent on a certain task and it is stored as text. Does anyone have suggestions on how this could be accomplished?

 

[pdx_man]

Check out the CDate() and Format functions.

 

[PhilH_23]

I can't get either of those to work to suit my needs. I'll try to clarify.

Format keeps the data type as text. I need to be able to average the values.

CDate changes it to a time of day. That isn't what I need. Here is a better example: "30:01:02" is one value in the table, this needs to be seen as 30 hours, 1 minute and 2 seconds. It is for time spent on an activity as opposed to time of day.

 

[PhilH_23]

I wrote a function to accomplish the task. Thanks for your help.