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...
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.
.png){kind=link}
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
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