Recent content by PhilH_23

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

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...

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?