A Sweet Performance by the Sister of the Bride

Posted on 1/3/2012 1:28:00 AM

At Christine and Paul's wedding, the sister of the bride performed a song written by herself. Closed captioning is included. Make sure to click on the "CC" icon to view the lyrics.

The close captioning is prepared by scrubbing the timeline in Premiere. Then clicked on the Preview window, copy and paste to an Excel spreadsheet.
100;00;30;0000;00;33;04When I think about the days,
200;00;33;1000;00;36;13In the Minnesota haze.
300;00;36;2500;00;40;16Snowmen and snowball fights.
400;00;40;0900;00;43;16Bundled up for the freezing nights.

However, Premiere/Encore Timecode format is different than in YouTube. For example,
00;00;43;16 <-- Premiere Timecode
00:00:43,16 <-- YouTube Timecode
Thus, the Excel REPLACE function is used to convert the format. For example, the cell in A1 can be converted from Premiere Timecode to YouTube timecode like this
REPLACE(REPLACE(REPLACE(A1, 3, 1, ":"),6,1,":"),9,1,",")
The last step is to create a YouTube CC Text Script looks like this
00:00:30,00 --> 00:00:33,04
When I think about the days,
00:00:33,10 --> 00:00:36,13
In the Minnesota haze.
00:00:36,25 --> 00:00:40,16
Snowmen and snowball fights.
00:00:40,09 --> 00:00:43,16
Bundled up for the freezing nights.

You can also use the same Excel spreadsheet to generate Text script for Encore DVD/BluRay authoring. Please refer to the blog post Adding Closed Captioning to Videos for more information.



Return to blog home page       Subscribe Mailing List

Latest Activity

Comments on "ALL-I vs IPB"

"[b][/b] ..."

Posted by 3aplus63minee
on 4/19/2020
Read More

Blog Archive

Dec 15    Facebook Group Photo Template (1)
Dec 1    Great Harddrives Storage Case 
Oct 20    Cables Required to Record Sound Feed from DJ 
Oct 12    Should I Offer Wedding Video Raw Footage? 
Oct 5    Digital Delivery for Event Filmmaker at BVA 
Sep 29    Awesome RODE PinMic  
Sep 15    Wedding Film Project Delivered using TakyBox vs Vimeo Pro  Feature Article
Sep 6    No More Sandbags 
Aug 28    External Backup System with Harddrive Dock 
Aug 8    ALL-I vs IPB (2)
Jul 24    Sole Proprietor, DBA, LLC, S-Corp...  Feature Article
Jul 17    Cloud Storage vs Cloud Backup (1)
Jun 12    Copyright Infringement Strike  
Apr 18    Audio Acquisition Comparison 
Mar 16    Color Tone Of Your Film 
Jan 8    Backup and Editing Workflow 
Jan 2    TakyBox V3 Official Release  Feature Article

Blog Home
Join Mailing List