AnsweredAssumed Answered

formula question

Question asked by leftcoastjim on Jul 17, 2010
Latest reply on Jul 19, 2010 by leftcoastjim


formula question


I have version 7 of filemaker, and have really just started getting into formulas.  Quite confusing for rookies.  I have a field called TC Duration which lists time code durations.  One entry looks like this 01:00:14:22.  This number represents hours:minutes:seconds:frames.  I have created a new field called MINS/SECS.  I want it to use TC Duration as its reference point, and to drop the first 2 digits and the last 2 digits so it displays 00:14, which represents minutes and seconds.  Can anyone supply the formula that would create this result?  Thanks