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,

      Chadi