3 Replies Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Convert Time Format "1 hour, 38 minutes, 12 seconds" - to Time Span "01:38:12"

    Allison Mangini

      Help!  I have a report with two columns that are text.  The columns show wait time and assist time in the following format:

       

      6 minutes, 36 seconds or

      1 second or

      1 hour, 12 minutes, 23 seconds

       

      How do I get this into a format like:

       

      00:06:36 or

      00:00:01 or

      01:12:23

       

      I would like to use these columns in a summary that I can sort by longest time, shortest time, etc.

       

      Does anyone have any experience converting text like this?  I will need to work this report on a monthly basis and am stumped on this part. :confused:

       

      Thanks for any help!

       

      Allison