2 Replies Latest reply on Oct 18, 2018 4:23 AM by Mahfooj Khan

    How to add ":" to a certain field?

    Chadi Atie

      Hi Guys,


      I have the field below, which is a time interval. I need to add ":" between the hours and the minutes:

      So for example:


      0000 --> 00:00

      0010 --> 00:10


      What is the formula that can do this?


      Thank you so much,