4 Replies Latest reply on Jan 13, 2019 11:14 PM 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