Like it or not spreadsheets are just too useful. Having the right formula to hand can really make things easier. Plus for me writing a bit of code serves to alleviate the tedium of data entry.
This expression will calculate the difference between two timecodes and spit out the answer in frames. Each cell must written using 11 characters in the standard timecode format. e.g. 10:23:07:24
This version works at 25 FPS and will subtract the IN point cell ‘G4’ from the OUT point cell ‘H4’.
You can change the frame-rate by swapping the 25 for a different number.
How it works
The MID function simply grabs individual characters from a cell.
Will grab 2 characters from cell H4 starting with the 7th character in the string.
E.g. It will grab 07 from 10:23:07:24
07 seconds * 25 fps = 175 frames