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

[Reelife_Folktography]

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

[Ann Bens]

Might need to write a script for that.

[Reelife_Folktography]

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:36	0:10:51
0:10:51	0:11:07
0:11:07	0:11:10
0:11:10	0:11:22
0:11:24	0:11:25
0:11:25	0:11:39
0:11:40	0:11:58
0:12:06	0:12:25
0:12:29	0:13:08
0:13:31	0:13:42
0:14:37	0:14:49
0:14:54	0:15:23
0:15:55	0:16:21
0:16:35	0:16:46
0:16:55	0:17:38
0:18:02	0:18:51
0:20:32	0:20:52
0:21:06	0:21:36
0:21:55	0:22:04
0:22:33	0:22:44
0:22:53	0:23:12
0:23:53	0:24:21
0:24:27	0:24:55
0:24:59	0:25:04
0:25:04	0:25:22
0:25:28	0:25:43
0:25:51	0:26:33
0:26:56	0:27:05
0:27:17	0:27:25
0:27:39	0:28:26
0:28:46	0:29:21
0:29:40	0:30:02
0:30:03	0:30:16
0:30:37	0:31:30
0:31:36	0:31:49
0:32:00	0:33:22
0:33:34	0:33:51
0:33:54	0:34:21
0:36:53	0:37:15
0:34:36	0:35:22
0:40:48	0:41:18
0:38:18	0:38:50
0:35:40	0:36:04
0:41:20	0:41:25
0:43:17	0:43:30
0:43:41	0:43:50
0:44:13	0:44:29
0:45:02	0:45:27
0:45:42	0:45:48
0:41:33	0:42:32
0:47:40	0:47:47
0:47:56	0:48:17
0:49:19	0:49:56
0:49:58	0:50:42
0:50:43	0:50:48
0:51:23	0:51:03
0:52:14	0:52:45
0:53:04	0:53:26
0:53:30	0:53:50
0:56:45	0:56:53
0:59:13	0:59:19
0:59:21	0:59:28
0:59:39	1:00:19
1:00:29	1:00:41
1:00:41	1:01:12
1:03:01	1:04:03
1:05:01	1:05:26
1:04:37	1:04:46
1:05:58	1:06:09
1:11:05	1:11:08

[Ann Bens]

@Bruce Bullis 

[Bruce Bullis · Accepted solution]

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).

[Reelife_Folktography]

Bruce, thanks for your reply. I appreciate it but unfortunately, I'm not a code guy and that all sort of looks like gobbledygook to me. 

[Reelife_Folktography]

fyi... Here is another reply I received:

"I would suggest that you convert the spreadsheet to edl, and then import the edl file. Obviously your spreadsheet needs to be formatted so the converter can read it accurately. There are plenty of converters around, a quick Google search brought this one in at the top: httpsxxxxx