6 Replies Latest reply on Jul 25, 2016 8:31 AM by Ashish Chaudhari

    Convert DD:HH:MM string to whole number

    Rachel Lambert

      Morning, all.

       

      My data extract includes a string that shows a duration of time (DD:HH:MM). I would like to be able to turn this number into an amount of hours, where 1:04:30 would equal 28.5 hours.

       

      Can anyone advise on this? See "Completion Time" in the attached workbook.