My previous post described a cue sheet that adds itself up using custom functions in Open Office, a technique that would work equally well in Excel. I took this approach because I was unaware that Google Docs has a scripting function that lets me do the same thing.
To cut a long story short, I've created a Spreadsheet template in the Google Docs template gallery that will add up your text timecodes.
My apologies to NTSC users (a large swathe of you), but the custom functions in this spreadsheet only work with integer framerates - 24, 25, 30, 50, 60. The template I've created is for PAL, but you would only need to change the formulas to use other framerates.
Please note: The recalculations on this are slow compared to a desktop app, and I've had to use a second worksheet to handle some of the cuesheet maths - the TRT cell doesn't seem to work if you embed too many nested functions in it.
Disclaimer
