Excel Formula for adding Timecode
Posted on 2011-02-24
I need to add video timecodes. I have a list of inpoints and corresponding durations, and I am trying to calculate the corresponding endpoints.
COL A COL B COL C
START DURATION END (This is the column to generate)
00:00:57:12 00:00:03:04 1:01:16
00:01:45:12 00:00:01:13 1:46:25
I found the following formula which would go in cell C3:
However, it's not always right. For example, the 'END' 1:01:16 above should really be 1:00:16.
The second one is correct.
Thanks so much for any help!