Unzip the download, and then drag the XLA file into Excel.ģ. Download the XLA script from here (I hope you don’t mind Matthias, but I’ve also mirrored it here – just in case your site ever goes down).Ģ. I tested this on MacOS 10.6.8 and Excel 2008.ġ.
Here’s a crash course for Mac users out there – although the workflow is very similar for PC users.
Although there is some great documentation floating around on the Internet ( this blog is probably the best resource – especially the comments), when I first downloaded it all I really wanted was a Installation Guide and an Example. It hasn’t been updated since 1997, however it still works great, even on the later versions of Excel. The tool I recommended was Excel Time Code Extension by Matthias Bürcher. Fortunately there are some great Macro’s out there that allow you to do just that, however the one I recommended is not terribly well documented, so I thought I would jot down some notes here. Today I was contacted by a filmmaker friend that wanted to work out a way to calculate timecode within an Excel spreadsheet. For those that no longer use Excel, there’s also a Google Sheets version explained here. UPDATE (26th January 2017): As Brad mentions in the comments below, you can now download the TC.XLAM 2.0 beta, which is no longer password protected and works on modern versions of Excel.
