Skip to main content
R
Reelife_Folktography
Known Participant
March 6, 2023
Answered

I have a list of in and out points from client. How can I automate these points from her spreadsheet

  • March 6, 2023
  • 1 reply
  • 984 views

How can I automate multiple in and out points from a spreadsheet to automate multiple edits on one long clip in a sequence? 

    This topic has been closed for replies.
    Correct answer Bruce Bullis

    It's not a particularly common need, as most workflows which have timecodes as text, also have the actual time values...

    The missing piece is code to translate between textual representation of times, and actual time values.

    This seems promising! 

    https://stackoverflow.com/questions/31385418/convert-timecode-to-seconds

    Once you have seconds, you should be able to use PPro's ExtendScript APIs (including the handy Time object).

    1 reply

    Ann Bens
    Community Expert
    Ann BensCommunity Expert
    Community Expert
    March 6, 2023

    Might need to write a script for that.

      R
      Reelife_FolktographyAuthor
      Known Participant
      March 6, 2023

      Thanks for your reply. I can't believe there's not a simple solution for this. Seems like it'd be a common need....

      How would I go about making a script? It will lieterally save me several hours of tedious work. Here's my in and out points:

       

      0:10:360:10:51
      0:10:510:11:07
      0:11:070:11:10
      0:11:100:11:22
      0:11:240:11:25
      0:11:250:11:39
      0:11:400:11:58
      0:12:060:12:25
      0:12:290:13:08
      0:13:310:13:42
      0:14:370:14:49
      0:14:540:15:23
      0:15:550:16:21
      0:16:350:16:46
      0:16:550:17:38
      0:18:020:18:51
      0:20:320:20:52
      0:21:060:21:36
      0:21:550:22:04
      0:22:330:22:44
      0:22:530:23:12
      0:23:530:24:21
      0:24:270:24:55
      0:24:590:25:04
      0:25:040:25:22
      0:25:280:25:43
      0:25:510:26:33
      0:26:560:27:05
      0:27:170:27:25
      0:27:390:28:26
      0:28:460:29:21
      0:29:400:30:02
      0:30:030:30:16
      0:30:370:31:30
      0:31:360:31:49
      0:32:000:33:22
      0:33:340:33:51
      0:33:540:34:21
      0:36:530:37:15
      0:34:360:35:22
      0:40:480:41:18
      0:38:180:38:50
      0:35:400:36:04
      0:41:200:41:25
      0:43:170:43:30
      0:43:410:43:50
      0:44:130:44:29
      0:45:020:45:27
      0:45:420:45:48
      0:41:330:42:32
      0:47:400:47:47
      0:47:560:48:17
      0:49:190:49:56
      0:49:580:50:42
      0:50:430:50:48
      0:51:230:51:03
      0:52:140:52:45
      0:53:040:53:26
      0:53:300:53:50
      0:56:450:56:53
      0:59:130:59:19
      0:59:210:59:28
      0:59:391:00:19
      1:00:291:00:41
      1:00:411:01:12
      1:03:011:04:03
      1:05:011:05:26
      1:04:371:04:46
      1:05:581:06:09
      1:11:051:11:08
      Regards, Tom Adams, Director/owner Reelife Documentary Productions
      Ann Bens
      Community Expert
      Ann BensCommunity Expert
      Community Expert
      March 6, 2023

      @Bruce Bullis 

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices