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



      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!