8 Replies Latest reply: Nov 15, 2016 6:37 AM by gaurav gopale RSS

    Convert field into HH:MM:SS

    gaurav gopale

      Hi

       

      I have a field as follows:

      Format(H.M.S)=0.0.1

       

      Time

      0.0.1

      12.03.1

      12.40.25

       

       

      I want to convert it in HH:MM:SS as follows

       

      Time

      00:00:01

      12:03:01

      12:40:25

       

       

      Can anyone help me in this

       

      Thanks in Advance