Oct 10 2021 05:10 AM
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,
Oct 10 2021 09:28 AM
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.
Oct 10 2021 09:50 AM
Oct 10 2021 09:52 AM
Oct 10 2021 10:21 AM
Excel use same symbol to separate milliseconds from hh:mm:ss time as to separate decimal part in the number, dot by default.
You actually have texts. To add 25/100 second you need to transform first your text to value, add millisecond and apply proper format. For example, if add to 00:26:41;26 formula could be
=SUBSTITUTE(A1,";",".")+250/24/60/60/1000
Oct 11 2021 05:56 AM
Oct 24 2021 01:15 PM - edited Oct 24 2021 01:16 PM
Milliseconds separated by period.
Oct 24 2021 05:09 PM - edited Oct 29 2021 08:23 AM
@Ruben79 wrote: ``Just so I'm clear, Excel separates seconds from tenths/hundredths/thousandths of a second with a colon or a period?``
Neither! It is the same as the "decimal separator" for all numbers.
Typically, that is comma or period, depending on your Regional and Language system options.
But you can override the system default by selecting the appropriate Excel Advanced option. However, beware that doing that affects the form of __all__ numeric values, no just time formats.
Oct 26 2021 03:40 PM