AnsweredAssumed Answered

Timecode in seconds

Question asked by ChrisJohnston on Jun 12, 2017
Latest reply on Jun 12, 2017 by 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

Outcomes