Help calculation seconds from Time Code.

thanks for reading,


i'm trying to find a equation that will convert time code (HH:MM:SS:FF) to seconds (S.SSS) with 29.97 rate value (e.g. 00:00:04;16 = 4.537)
i guess is very simple but i cannot wrap my head around it.

thanks in advance.

Try this... http://www.mediachance.com/dvdlab/freetime.htm

You can do a simple spreadsheet in excel

Here you go:
http://www.mediafire.com/?5fgtdd5yk1h

Fill in the yellow boxes with the info, and the red box is the conversion in seconds

hours in seconds = hours x 60 x 60
minutes in seconds = minutes x 60
seconds = seconds
frames in seconds = frames / frame rate

Add those 4 together