3 Replies Latest reply on Dec 12, 2009 1:15 AM by comment_1

    Trouble with auto formating calc

    Steppyb

      Title

      Trouble with auto formating calc

      Post

      I'm trying to create a formating calculation that will allow me to format time code.

      The editors would enter "010005"

      It would format to add in the :

      So it would become "01:00:05"

      I modified the code for formatting phone numbers to:

      Case(Length(Source_TC_in) = 6; Left(Source_TC_in;2) & ":" & Middle(Source_TC_in;2;2) & ":" & Right(Source_TC_in;2); "error")

       

      My problem with the calc is that when I enter (for example) 010508

      it changes the middle two number to something like 01:01:08.

       

      I'm on FM9 on a Mac.