Time code formula for film

Welcome to the Board

I'm sure daddylonglegs himself will look on this and provide a more elegant method but I guess I'd probably opt for something like the below...

NOTE: the below utilises functions DOLLARDE & DOLLARFR - both require activation of the Analysis ToolPak in Excel 2003 via Tools -> Add-Ins.

A1: (onwards) contain Start Times in format of hh:mm:ss:ff
B1: (onwards) contain End Times in format of hh:mm:ss:ff

where ff has a base of 24

I'd probably be inclined to convert Start & End values into Seconds based values in adjacent cells, such that

Please Login or Register  to view this content.

The difference can then be shown in terms of seconds.frames using

Please Login or Register  to view this content.

To then sum the durations (with the base of 24 f per sec), if we assume we have times in rows 1 to 10 we can calculate the total duration in terms of sec.frames using:

Please Login or Register  to view this content.

In terms of displaying the above in hh:mm:ss ... what do you want to do with the frames ? You could show as milliseconds if that's your wish ?

To do so, add a division of 86400 to the above formula and format E11 as hh:mm:ss.00

To reiterate I'm convinced there's a better, more elegant method which dll will provide in due course - hopefully in the meantime the above will help you progress the project ?

With E11 active press CTRL + 1 to bring up the format cell dialog, on the Number Tab choose Custom and in Type box enter: hh:mm:ss.00

And just to confirm re: division,

E11: =(existing formula)/86400

Rather than installing multiple headers for the sake of printing why not use "Rows to Repeat" funtionality in your Page Setup ?

Welcome to the forum, Alan.

Please take a few minutes to read the forum rules, and then start your own thread.

Thanks.