Newest functions Upload a function Leave a tip My account

There are 2,609 functions in this library.

Timecode_To_Frames ( timecode ; fps )

Convert film and tv timecode into frame count

  Average rating: 4.8 (23 votes) Log in to vote

Mike Parsons Reverberation http://www.revfx.tv

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

If( fps=29.97; // test for special case of drop frame (SMPTE) timecode Right("00"&((Int((Int((Int((frames+18*Int(frames/17982)+2* Int((Int(Mod(frames;17982)) -2)/1798))/30))/60))/60))-(Int((Int((Int((Int((frames+18*Int(frames/17982)+2* Int((Int(Mod(frames;17982)) -2)/1798))/30))/60))/60))/24)*24));2) &":"& Right("00"&((Int((Int((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982)) -2)/1798))/30))/60))-(Int((Int((Int((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982)) -2)/1798))/30 ))/60))/60)*60));2) &":"& Right("00"&((Int((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982)) -2)/1798))/30))-(Int((Int((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982)) -2)/1798))/30 ))/60)*60));2) &";"& Right("00"&((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982))-2)/1798))-(Int((frames+18*Int(frames/17982)+2*Int((Int(Mod(frames;17982)) -2)/1798))/30 )*30 ));2) ; Right("00"& Mod(Int(Int(Int(frames/fps)/60)/60);24);2) &":"& Right("00"&Mod(Int(Int(frames/fps)/60);60);2) &":"& Right("00"&Mod(Int(frames/fps);60);2) &":"& Right("00"&Mod(frames;fps);2) ) Click to copy

Converts film and tv timecode strings eg 01:05:20;02 @ 29.97 fps into a framecount in this case 117484

The calculation traps for the special case of drop frame 29.97 timecode and allows for all other interger fps values.

 

Comments

		HOnza, Prague Oct 24, 2013
I suggest you rename this function as Timecode_To_Frames ;-)

		Mike Oct 24, 2013
Ha thanks for that - id discovered the plugin I used didn't want to work anymore so dug out my old timecode calcs, I thought I'd uploaded all 6 but it seems only one stuck. I'm on a movie at the moment but will put up the rest next week when I get home. I also had a heap of key code calcs but other than as a history lesson be a bit pointless uploading them. Mike

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: