conversion formula for TV Frame rate's

  • Thread starter Thread starter Qboulder
  • Start date Start date
Q

Qboulder

Hi, I no there's probably a really easy way to do this, as I can work i
out in my head without any trouble, but I'm trying to work out
formula in Excel that converts lets say 100 frame's into 00:04:0
format. Can it be done? and am I really stupid
 
Qboulder,

I assume you want a formula for 24 frames per second.

Try the following formula:

=TEXT(INT(B18/1440),"00")&":"&TEXT(INT((B18-INT(B18/1440)*1440)/24),"00")&":"&TEXT(MOD(B18,24),"00")

The formula returns the result as text, so you can't do any calculations on the results. If you want do do that, I believe it can be done with a worksheet formula, but in that case I would create a user defined function instead.

The formula only coverts to minutes, seconds and frames - hours are charged extra :)

HTH
Anders Silvén
 
Another option might be the following.
If you are using 100 & 24, then perhaps...

=100/24/86400

where 86400 is the number of seconds in a day.

Then custom format with "mm:ss.ss"

This displays 00:04.04 for me.
 
Back
Top