I have three fields:
Field 1: timeStart
Field 2: timeEnd
Field 3: totalTime
Field 1 and 2 have this Calculation associated with them:
Let ( [ t = offense_Time_Start // ######## - 8 digits ;
Left( t ; 2 ) & ":" &
Middle( t ; 3 ; 2 ) & ":" &
Middle( t ; 5 ; 2 ) & ":" &
Right( t ; 2 ) // returns as ##:##:##:##
What these fields track are the video frames in Adobe Premier Pro so if I want to track an event 'timeStart' I am tracking the frame and not the time per say. So for example it would be: 00022522 then the field calcs back: 00:02:25:22. So at 00:02:25:22 a specific event happened.
I leave Field 2 blank most of the time and would like to have this but not sure 'If' or 'Case' statement:
If Field 2 is blank then copy contents from Field 1 and paste into Field 2.
Now even though the fields track time what it really is, is the moment something starts and stops and that is in frame/time so to speak. When I enter a time into field 1 its an actual frame or moment in the video I want to record so I can go back and reference the exact time something happened. With that said once I enter a moment into field 2 it now becomes a span of time and Field 3 is suppose to subtract field 2 from 1 and display the total amount of time an event occurred.
I cannot use the Time field in FM because I need the actual frame count and that is 00:00:00:00 'These last two digits are for the frame. There are 24 frames per second'
So doing a simple subtraction does not work.
Field 1 - 00023312 (Calcs to 00:02:33:12)
Field 2 - 00034005 (Calcs to 00:03:40:05)
Field 3 - 0010693 (Calcs to 00:10:69:3 or something like that)
See it does not work but should be 00020717 (Calcs to 00:02:07:17)