AnsweredAssumed Answered

Easy Copy Paste and Custom Nightmare Calc ;)

Question asked by MartyGlenn on Jul 31, 2018
Latest reply on Aug 1, 2018 by MartyGlenn

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.

 

Example:

 

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)

 

Thank you.

Outcomes