Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for timecode duration
I am trying to subtract a field of film timecode from another, what do need to get teh formaula to understand that there are 25 frames in second (or whatever I happen to be using at the time) and then subtrac one form teh other to give the number of frames duration. I need all te help I can get it has been years since I've programmed in excel -- wrain ----------------------------------------------------------------------- wraine's Profile: http://www.msusenet.com/member.php?userid=251 View this thread: http://www.msusenet.com/t-187055568 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for timecode duration
See if this previous post helps
http://google.com/groups?threa*dm=77...*r.pol. co.uk -- HTH Bob Phillips "wraine" wrote in message ... I am trying to subtract a field of film timecode from another, what do i need to get teh formaula to understand that there are 25 frames in a second (or whatever I happen to be using at the time) and then subtract one form teh other to give the number of frames duration. I need all teh help I can get it has been years since I've programmed in excel. -- wraine ------------------------------------------------------------------------ wraine's Profile: http://www.msusenet.com/member.php?userid=2516 View this thread: http://www.msusenet.com/t-1870555681 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for timecode duration
http://groups-beta.google.com/group/...e=source&hl=en
http://www.belle-nuit.com/timecode/ -- Regards, Tom Ogilvy "wraine" wrote in message ... I am trying to subtract a field of film timecode from another, what do i need to get teh formaula to understand that there are 25 frames in a second (or whatever I happen to be using at the time) and then subtract one form teh other to give the number of frames duration. I need all teh help I can get it has been years since I've programmed in excel. -- wraine ------------------------------------------------------------------------ wraine's Profile: http://www.msusenet.com/member.php?userid=2516 View this thread: http://www.msusenet.com/t-1870555681 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for timecode duration
it didn't do anything when i tried the link. gave me the other frame but no useful text. is the address right -- wrain ----------------------------------------------------------------------- wraine's Profile: http://www.msusenet.com/member.php?userid=251 View this thread: http://www.msusenet.com/t-187055568 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula For Time Duration Calculation | Excel Discussion (Misc queries) | |||
Formula help: Duration Without Weekend Days | Excel Discussion (Misc queries) | |||
Does anyone have a formula for SMPTE timecode in Excel? | Excel Discussion (Misc queries) | |||
Time duration formula | Excel Discussion (Misc queries) | |||
Excel Time Duration Formula | Excel Worksheet Functions |