8 Replies Latest reply on Apr 23, 2019 6:06 PM by Christine Curtis

    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


      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