Forum Discussion
How to increase timecodes by the same amount in two columns on Excel?
Hello,
Thank you in advance for your help.
I have Microsoft Office Professional Plus 2016 and am trying on an Excel spreadsheet to increase the timecodes in two columns by seconds, and tenths & hundredths of a second, for in-and-out music cues on a film. The amount I need to increase each cell by is 00:00:37;23 and this is the timecode format I'm using is 00:02:40;09 (that's the first cell).
I've tried everything I've seen in my searches but nothing seems to work. Any help on this is appreciated.
Best,
8 Replies
What exactly means the part after semicolon (e.g. 00:29:04;26) - 26 means frames or 26/100 sec or what?
Could you please illustrate in sample file how desired result shall looks like.
- Hello Sergei,
Thank you for your response. The ;26 mean 26/100 secs. So if the first cell in the screenshot has a value of 00:29:04;26 I need to add 00:000:37;23 to it (and to all the cells in both columns).
Also, the reason I have a semi-colon before the tenths/hundredths of a second is because that's how the editing program (Sony Vegas Pro) indicates those parts of a second (not with a colon or period.) Will the fact that it's a semi-colon be an issue in solving this?
Ruben
.png){kind=link}