7 Replies Latest reply: Nov 14, 2016 12:40 PM by Sunny Talwar RSS

    Convert Time into minute

    gaurav gopale

      Hi

      i have field as follows

       

      Time

      1Day20Hrs30Min25Sec

      2Day20Hrs45Min25Sec

      1Day24Hrs30Min25Sec

      1Day16Hrs30Min25Sec

      3Day14Hrs30Min25Sec


      I want to convert the above field into HH:MM:SS




      Can anyone help me?



      Thanks in advance