A recent thread on LAFCPUG.org raised the question of whether one could use a spreadsheet, like Excel, to log timecode and have it automatically calculate duration for each clip, as well as overall duration. I volunteered to look into it, and here is the result. Now you can log shots and determine duration without having to run back and forth to a timecode calculator. Accompanying this document is an Excel spreadsheet with the formulas to accomplish this. Consider it a template, to be expanded and modified to your needs. Feel free to contact me with questions and kudos.
TAGS: “logging, spreadsheet, import log”