If anyone was having trouble, like I was, it looks like Premiere Pro now requires frames to be included. So for a 1 second timecode you need: 00:00:01:00 instead of the 00:00:01 shown in this video. Premiere Pro kept reading the .srt file incorrectly until I added the extra zeros.
@@amaexpert So its a little fiddly, first you need to do the column normally as shown in the video. Then add a second column next to it that references the first column with the formula =A1&":00" That should then add the :00 to the end of every cell. From there I just copied the cells and pasted them into the first column using only the values. Hope that makes sense.
Thanks for watching! If you'd rather skip the part where you make the subtitle file, you can purchase up to an hour of pre-made timer captions here: www.thepremierepro.com/store/timer-captions
possibly one of the most useful videos ever! - thank you so much - I found this also works using a CSV imported into Editingtools - its important to use TEXT in the spreadsheet to get the numbers to appear correctly (i.e. 00:00:00 and not 0:00:00)
Thanks Chris! You need to drag down 1 cell for every second in you timer, so 10 minutes = 600 cells (+1 for the header). I don't think the extra 0 should be a problem, but if it is, you can easily change the display format in Google Sheets by selecting the entire column, and choosing Format > Number > More Formats > More date and time formats. There you can change 'Elapsed Hours' to 'Elapsed Hours with Leading Zero'.
Hello ! Thanks for the video, it's really helpful. I'm just having a problem with the file. When I convert it in EditingTools, there is only one of my subtitles that is being converted even though in my google sheet file everything is correct. Do you have a solution for that?
Thanks for this. Didn't even think to use subtitles, but it is so much easier than all the other videos I found that try to shoehorn the timecode effect into working as a count down. And once the srt files are built, it's a really quick process.
Hey Downloaded and worked great.... i'd like a 90 minute timer for a project im working on.... but it be really laggy trying to edit them even with the hour timer
Thanks very much. Purchased the timer files to save myself some time. This solution is a lot more elegant than the timecode hack, which doesn't allow you to change fonts.
man thank you so much for this!! the amount of time i’ve spent watching tutorials and trying other methods that just never quite worked properly with really long timers, this is perfect and so easy to do. much appreciated!
so when I import my SRT file it creates a subtitle track but doesn't fill it with anything. I looked over the SRT file and all seems normal. any ideas?
I can't get this website tool to generate the SRT file correctly, it comes out all wonky. I'm just going to use the other method I found the link to this video in.
For me google sheets is automatically changing "00:00:00" to "12:00:00 AM" and 0:00 in the actual cell. It throws off the whole algorithm so that the count down doesn't change one second at a time... Any idea why?
Not sure why it's forcing you to use that specific time format, but you can change the format by selecting the column and going to Format > Number > Custom Date & Time.
@@ThePremierePro Hey I'm having the same issue, I've tried with both sheets and excel. It seems even if I finally get the formatting correct with the custom option, the numbers won't fill down correctly in a sequence... Quite frustrating! How is your google sheets not automatically correcting your numbers into dates, as well as let you fill the numbers down?
This looks great! But...I've tried so many different versions and nothing actually shows up in Premiere Pro. I'm trying to import a 1 minute timer subtitle, but I've only gotten two titles to show up at the most. I already tried adding the milliseconds and trying a bunch of different number formats in google sheets. I'm really hoping to get this to work. Any ideas? Thanks!
Good question! After exporting the video with the timer captions burned-in, enable your other captions track and choose File > Export > Captions to create the sidecar file.
Hi Farah, if you have your Text panel open, you may need to click the Captions tab (instead of Transcript). Either way, you can also import captions using File > Import.
Sounds like there's an issue with your SRT file. Try opening it in any text editor and see if you can spot the problem. Otherwise, email it to me and I'll take a look at it.
I've attempted to do this, change the formatting, and still no luck. I made sure the sequence was at 30fps as well. The first time I tried it, captions showed from 14:27 and jumped to 14:01 and then 13:27.
@@ThePremierePro It appears it has to do with the milliseconds format. When I've ran it through the website recommended the milliseconds don't get added. So went back into Google Sheets to add ",000" to the numbers and it worked okay. The 6 digits as shown 00:00:00 apparently need the milliseconds as well.
@@robertosoracco15 Roberto I've been having the exact same problem. Can you let me know exactly how you are formatting your numbers. Is it 00:00:00,000 ??
Figured it out! Yes it needs to read 00:00:00.000 and then it populates correctly when imported into Premiere. So glad this works now this is amazingly helpful!!
Hi there! I've been getting a problem with uploading my SRT file to my Premiere Pro. As I upload it to captions, I am unable to do so as it tells me that "the file cannot be opened because of a header error". Does anyone know how I can fix this? Thank you so much!
@@ThePremierePro Good day! I'm good now. I wasn't sure what went wrong, and I decided to restart my laptop and re-do everything, and eventually it worked. But, I am glad i fixed it somehow! Thank you so much for your video! It saved me tons of time and is incredibly helpful. Keep it up! 💯
Yep, the best way to do this would be to duplicate the 1 hour SRT file, open it in any text editor and find/replace "1:" and "0:" with "2:" and "1:". Then import both subtitles into your project. (if you have any issues, shoot me an email)
Header error, and using this system no online editor or notepad can edit it to correct the information. Use a different tutorial if you run into this issue.
Hello ! Thanks for the video, it's really helpful. I'm just having a problem with the file. When I convert it in EditingTools, there is only one of my subtitles that is being converted even though in my google sheet file everything is correct. Do you have a solution for that?
If anyone was having trouble, like I was, it looks like Premiere Pro now requires frames to be included. So for a 1 second timecode you need: 00:00:01:00 instead of the 00:00:01 shown in this video. Premiere Pro kept reading the .srt file incorrectly until I added the extra zeros.
But how do you make that in Google Sheets? When I try what you say, it's making every frame a step, like 00:01:00:01 etc
@@amaexpert So its a little fiddly, first you need to do the column normally as shown in the video. Then add a second column next to it that references the first column with the formula =A1&":00" That should then add the :00 to the end of every cell.
From there I just copied the cells and pasted them into the first column using only the values.
Hope that makes sense.
Good advice!
Thanks!!
THANK YOU! Could not figure out why I couldn't get this to work
Thanks for watching! If you'd rather skip the part where you make the subtitle file, you can purchase up to an hour of pre-made timer captions here: www.thepremierepro.com/store/timer-captions
Your videos are very very helpful and infomative.
possibly one of the most useful videos ever! - thank you so much -
I found this also works using a CSV imported into Editingtools - its important to use TEXT in the spreadsheet to get the numbers to appear correctly (i.e. 00:00:00 and not 0:00:00)
Thanks Chris! You need to drag down 1 cell for every second in you timer, so 10 minutes = 600 cells (+1 for the header). I don't think the extra 0 should be a problem, but if it is, you can easily change the display format in Google Sheets by selecting the entire column, and choosing Format > Number > More Formats > More date and time formats. There you can change 'Elapsed Hours' to 'Elapsed Hours with Leading Zero'.
@@ThePremierePro ah thanks that’s perfect - honestly enjoying trying out variations of this - it’s so useful
@@ThePremierePro Format > number > more formats = no longer present in sheets.
@@MushroomFleet Try Format > Number > Custom Date & Time
@@ThePremierePro thanks i got it, you gotta deselect the hours too on column 3, thanks!
Hello ! Thanks for the video, it's really helpful. I'm just having a problem with the file. When I convert it in EditingTools, there is only one of my subtitles that is being converted even though in my google sheet file everything is correct. Do you have a solution for that?
Thanks for this. Didn't even think to use subtitles, but it is so much easier than all the other videos I found that try to shoehorn the timecode effect into working as a count down. And once the srt files are built, it's a really quick process.
Thanks, I'm glad to hear it was useful!
The little blue box trick is new to me. Amazing!
Hey Downloaded and worked great.... i'd like a 90 minute timer for a project im working on.... but it be really laggy trying to edit them even with the hour timer
Thanks very much. Purchased the timer files to save myself some time. This solution is a lot more elegant than the timecode hack, which doesn't allow you to change fonts.
Thanks! Good luck with your videos John.
man thank you so much for this!! the amount of time i’ve spent watching tutorials and trying other methods that just never quite worked properly with really long timers, this is perfect and so easy to do. much appreciated!
This makes me very happy :)
so when I import my SRT file it creates a subtitle track but doesn't fill it with anything. I looked over the SRT file and all seems normal. any ideas?
Email me your SRT file and I'll take a look at it.
I can't get this website tool to generate the SRT file correctly, it comes out all wonky. I'm just going to use the other method I found the link to this video in.
You have to have a pro account if you want to do a longer timer.
❗ Tell us in one of the videos what stand-alone clips are and why they are needed at all. What useful work can be done with them? 🤷♂️
special thanks for the professional resources for editors 👏👍
Super
For me google sheets is automatically changing "00:00:00" to "12:00:00 AM" and 0:00 in the actual cell. It throws off the whole algorithm so that the count down doesn't change one second at a time... Any idea why?
Not sure why it's forcing you to use that specific time format, but you can change the format by selecting the column and going to Format > Number > Custom Date & Time.
@@ThePremierePro Hey I'm having the same issue, I've tried with both sheets and excel. It seems even if I finally get the formatting correct with the custom option, the numbers won't fill down correctly in a sequence... Quite frustrating! How is your google sheets not automatically correcting your numbers into dates, as well as let you fill the numbers down?
@@laughingcow5389 Hi Anika, can you email me your Google sheet and I'll take a look at it?
@@ThePremierePro Just sent! Thanks so much
@@laughingcow5389 @The Premiere Pro was there a solution found? Im having the same issues
This video is always useful -- in fact, last weekend at Andy Webb's wedding, me and Jeremy Workman were kvelling over how great this channel is!
THE Jeremy Workman??? Appreciate all the kvelling, offline and on :)
@@ThePremierePro I didn't check his identification, but he said he was Jeremy. It has been a while since I've seen him, though.
This looks great! But...I've tried so many different versions and nothing actually shows up in Premiere Pro. I'm trying to import a 1 minute timer subtitle, but I've only gotten two titles to show up at the most. I already tried adding the milliseconds and trying a bunch of different number formats in google sheets. I'm really hoping to get this to work. Any ideas? Thanks!
Did you want to email me your TSV and SRT file and I'll take a look at it?
@@ThePremierePro That would be amazing! I'll send it over right now. Thank you!
I tried to do this in Premiere Pro CC 2019, but didn't get it to work. I even bought the subtitle-files. :(
I don't think 2019 is supported, since that was Premiere's old subtitle system. Shoot me an email and I'll organize a refund for you.
Any work around for ALSO having regular captions, eg, burning one track of captions to the video and exporting the other captions as a sidecar file?
Good question! After exporting the video with the timer captions burned-in, enable your other captions track and choose File > Export > Captions to create the sidecar file.
(also, you add another captions track by choosing Sequence > Captions > Add New Captions Track)
@@ThePremierePro Thank you so much!
Hello there, thank you for this, but I don't know why I don't have the import captions from file in the text section, any idea how can I fix this pls?
Hi Farah, if you have your Text panel open, you may need to click the Captions tab (instead of Transcript). Either way, you can also import captions using File > Import.
@@ThePremierePro thanks I passed with success this phase
The numbers keep slowly moving up and then a new set of number show up from the bottom slowly. How can this be remedied?
I tried all day with no luck. I just purchased the pre-made timer. Thanks for trying tho.
Do you mean you were unable to make the timers yourself or you're having issues with the pre-made timers?
When I import my file into Premier Pro, it just loads the first time mark -- in my case, 3:00 for a 3 minute timer. But nothing else. Any ideas?
Sounds like there's an issue with your SRT file. Try opening it in any text editor and see if you can spot the problem. Otherwise, email it to me and I'll take a look at it.
Keep going bro🙂❤ miss you so much!
Thanks Esteem - I'll be back soon!
Any way I could do this quickly with a clock that has PM/AM?
Select your Subtitle column in Google Sheets, choose Format > Number > Custom Date and Time, and choose the time format that uses AM/PM.
I've attempted to do this, change the formatting, and still no luck. I made sure the sequence was at 30fps as well. The first time I tried it, captions showed from 14:27 and jumped to 14:01 and then 13:27.
Hi Roberto - email me your captions file and I'll take a look at it.
@@ThePremierePro It appears it has to do with the milliseconds format. When I've ran it through the website recommended the milliseconds don't get added. So went back into Google Sheets to add ",000" to the numbers and it worked okay. The 6 digits as shown 00:00:00 apparently need the milliseconds as well.
@@robertosoracco15 Roberto I've been having the exact same problem. Can you let me know exactly how you are formatting your numbers. Is it 00:00:00,000 ??
Figured it out! Yes it needs to read 00:00:00.000 and then it populates correctly when imported into Premiere. So glad this works now this is amazingly helpful!!
@@RyanSSmith Great, glad to hear it worked!
PLs upload new vid, I dont want you to be demonitized. I love your work.
Thanks June - I'm editing a feature film at the moment, but hoping to upload more tutorials once it's finished.
Hi there! I've been getting a problem with uploading my SRT file to my Premiere Pro. As I upload it to captions, I am unable to do so as it tells me that "the file cannot be opened because of a header error". Does anyone know how I can fix this? Thank you so much!
Did you want to email me your SRT file and I take a look at it?
@@ThePremierePro Good day! I'm good now. I wasn't sure what went wrong, and I decided to restart my laptop and re-do everything, and eventually it worked. But, I am glad i fixed it somehow! Thank you so much for your video! It saved me tons of time and is incredibly helpful. Keep it up! 💯
@@imnotokay252 Thanks, great to hear it's working!
Please make video on how to make intro like yours.
Will do, I'll add it to my list.
@@ThePremierePro thanks man !
Can I change your one hour long timer to 2 hours?
Yep, the best way to do this would be to duplicate the 1 hour SRT file, open it in any text editor and find/replace "1:" and "0:" with "2:" and "1:". Then import both subtitles into your project. (if you have any issues, shoot me an email)
it ransates to mili seconds for me
It should still work with milliseconds, but you can always change the format in Google Sheets using Format > Number > Custom Date and Time.
Header error, and using this system no online editor or notepad can edit it to correct the information.
Use a different tutorial if you run into this issue.
You may need to add frames to the timecode, e.g. 00:00:01 should be 00:00:01:00.
❗And then there will be development ? have you been waiting for 👈
Big waste of time, spreadsheets won't go past one second, captions workspace doesn't function like in the video, I'm moving on.
it's been two hours trying it and it's not working for me :(
Let me know at which stage it is not working for you and I will try to help.
@@ThePremierePro when I import the art file, it does not appear in adobe premiere ... and I get no error message, plus I cant see the subtitles
What a ridiculous and clunky solution
Hello ! Thanks for the video, it's really helpful. I'm just having a problem with the file. When I convert it in EditingTools, there is only one of my subtitles that is being converted even though in my google sheet file everything is correct. Do you have a solution for that?
Try adding milliseconds to your timecode in Google Sheets (00:00:00.000) and then run it through Editing Tools again.
@@ThePremierePro I am having the same problem and that didn't work.