Calculate Timecode in Filemaker Pro 12
Hi all
I have a FMP PRO 12 database whit various Timecode fields in the same record
Is there a way to calculate the duration between the OUT timecode and the IN time code?
The record will look like this
TimeCodeIN 00:00:25:12
TimeCodeOUT 00:00:29:14
The result should be
Duration: 00:00:04:02
My timecode base is in pal therefore the frame numbers are always 25
Thanks
Mac Pro, OS X Mavericks (10.9), null