Googling for “excel timecode” didn’t produce any results which met my requirements:
- support 29.97 drop-frame SMPTE timecode
- calculate a duration given an in-point and out-point
- provide conversion to and from timecode, frame count and microseconds
- not based on Excel macros so that the solution can be easily redistributed
Because of this, I am pleased to present a solution which does meet the above requirements: