7 Replies Latest reply on Feb 7, 2019 3:40 AM by Mahfooj Khan

    Convert String into HH:SS:MM

    Benjamin Rubattel

      Hello, I have a field that capture the document creation time.

       

      The issue is that the format of this field is, for example, either:

       

      93539 (5 numbers) for 09:35:39

      Or

      102743 ( 6 Numbers)  for 10:24:43 Seconds.

       

      I am looking for a formula to add convert this into HH:MM:SS

       

      I am not sure what calculated field could be created for this, any advice would be more that welcome.

      thank you

      Benjamin