AnsweredAssumed Answered

Trouble with auto formating calc

Question asked by Steppyb on Dec 11, 2009
Latest reply on Dec 12, 2009 by comment_1

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. 

Outcomes