Is it possible to create a field in a Timecode format and calculate it?

I want a user to enter in timecode in and out in this format ( 00:00:00:00 )

It has to calculate (hours:minutes:seconds:frames) and output the total to give the user the duration of the clip.

I haven't been able to figure it out a formula or anything else to get this to calculate properly...

Also, how would I create an Imput mask for this?

Sorry, I am really new at this part of Filemaker.

Well, a simple way would be to demand that your users enter ALL characters of the desired timecode. IOW, don't leave off any zeros.

Now you can pull apart the passed timecode based on the position of the text. (I would place the separated pieces into global fields and calculate that way.)Any number at positions 1 or 2 is an hour part. Any numbers at positions 4 & 5 are minutes, 7 & 8 are seconds and 10 & 11 are frames.

Take a look at the text functions list, particularly ValueCount(), MiddleWords() and Length().

Is that what you were looking for?

Kurt

Actually, a better idea would be to place the global fields directly on a layout with only text colons between them for display. Then the use would be entering the data directly into first an hour field, then a minutes field, then seconds and finally the frames.

You will have to be very careful to increment your calculaions based on the frames, too. I haven't thought about what formula you would use but I will try. The frames count is definietly where you may trip up.

I've used seperate fields for each element. I also found that this helped with the duration calculation.

Good Luck.

Garry