3 Replies Latest reply on Jun 12, 2017 7:55 AM by ChrisJohnston

    Timecode in seconds

    ChrisJohnston

      I have a set of timecode (video) that gets generated by a media player. The timecode is used in a my solution. For example, I wanted to get the timecode in seconds of 01:04:54 . Was able to do the math for the Timecode of 01:04:54 to end up at 3894 seconds like so...

      Let (                                                     
      [                                                        
      @hourSecs = (GetAsNumber(Left(clip_in;2)) * 60) * 60;    
      @minSecs = GetAsNumber(Middle(clip_in;4;2)) * 60;        
      @secSecs = GetAsNumber(Right(clip_in;2))];               
      @hourSecs + @minSecs + @secSecs                          
      )                                                        

       

      My question is how do I go the other way. For example with 3894 and a number like 7253, how could I end up with 01:04:54 or 02:00:53 respectively? I realize I will have to put back the colons (":"), that I can do. As for the math, I can figure them out, but I would like to know a good method of doing this with FileMaker functions. Thanks