Belle Nuit Montage - 16mm et Avid - Place du Château - Lausanne - Suisse - e-mail: matti@belle-nuit.com

Excel Time Code Extension

Homepage | Recherche | Archives | Avid | DV | EDLWriter | Montages | Subtitler | TCplus | Time Code | Links
Texte français | Deutscher Text

TC.XLA 1.1. (with Drop-Frame)

by Matthias Bürcher © 1997

Freeware

This macro is a little utility for all who work in Video and Film Postproduction. It gives you the ability to handle Time Code in Microsoft Excel Worksheets. You put the extension in the Macro Library Folder and it's functions are understandable by itself.Firstly, it formattes numbers as Time Code, and secondly it enables you to calculate with Time Code. Version 1.1. supports Drop Frame and has a new Summary-function.

 

Downloading

The file doesn't include an explaining text, so keep this web-page for your documentation. Please refer to the french version for the complete text

TCtoframes(TC;fps)

TCtoframes(00:00:02:05;24)=53
TCtoframes(00:00:02:05;25)=55
TCtoframes(00:00:02:05)=55

framestoTC(frames;fps)

framestoTC(53;24)=00:00:02:05

TCplus(TC1;TC2;fps)

TCplus(01:00:01:02;00:00:03:00;25)=01:00:04:02

TCminus(TC1;TC2;fps)

TCminus(01:00:01:02;00:00:03:00)=00:59:58:02

TCmult(TC1;facteur;fps)

TCmult(00:00:02:05;2)=00:00:04:10

TCdiv(TC1;facteur;fps)

TCsum(TCref;fps)

TCtrans(TC;fromfps;tofps)

TCtrans(00:00:01:02;24;25)=00:00:01:01

TCtofeet(TC;gauge;fps)

TCtofeet(00:00:01:00;35;25)=1.09
TCtofeet(00:00:01:00;16;25)=0.25

feettoTC(feet;gauge;fps)

TCtometer(TC;gauge;fps)

metertoTC(meter;gauge;fps)

timetoTC(intime)

TCtotime(inTC)

texttoTC(intext)

texttoTC(01:00:01:17) = 01000117

TCtotext(inTC,fps)

TCtotext(01000117) = "01:00:01:17"

isTC(TC;fps)

Homepage | Recherche | Archives | Avid | DV | EDLWriter | Montages | Subtitler | TCplus | Time Code | Links
Texte français | Deutscher Text

since 2000: | e-mail:matti@belle-nuit.com | www.belle-nuit.com 14.2.00