Search results

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?