video timecode, find records by duration

[cbm]

I know there must be an easier way to do this ... I'm working on a database that keeps track of assets in a production environment. I need to be able to track the duration (hh:mm:ss:ff ... frames could probably be dropped) of the videos and to be able to a search for videos of a certain length (30 minutes).

I've come up with a less than elegant solution. Users enter hh mm ss frames in separate fields. I have a calculation field to figure out minutes and a search page where a user enters a range in minutes (eg 00..120).

does anyone have a sample database/calculations that makes it easier for a user to enter timecode and to do a search for a video of a certain length?

thank you

[mr_vodka]

How about using a regular time field to enter the time format as HH:MM:SS (use time formatting options here for 24 hour notation) and then the calc to get your number of minutes to be:

Hour ( duration ) *60 + Minute ( duration )

[comment]

Link

[cbm]

Thank you for the replies. In this case, I don't have an in and out .. just a total duration of the video.

I tried creating a field based on time 24 hours but the results didn't make sense (seemed to be based on am and pm)? The formula that you mentioned is the one that I was using in having people enter hh mm ss in separate fields.

I'm sure I'm missing something basic.

Thanks for the post about time in and out ... I did see this (part of the reason for avoiding frames -)

Thanks again for your help

[comment]

I am not sure I understand your problem. If you only have durations, and you are willing to ignore the frames bit (which seems reasonable), you can use a regular time field to record the duration.

A time field as such is not based on 24 hours or 12 hours, or anything. You can input any value up to 2147483647:59:59 (including negative values). The 12/24 business concerns data entry and display only.

[cbm]

thanks for the reply. I had the field set up as "time" ... when i tried to do a search (eg. between x minutes and y minutes) I received an error saying that it needed to be formated as a time in am or pm.

I changed the field to a calculation and added hh mm ss instructions following instructions from another post. It seems to work now.

I need to set up a search to have users enter time 1 and a time 2 to find videos between the two times (e.g. 0 and 60 minutes) (I know that I can have them enter 00..60 but it doesn't seem like an elegant solution). I'll investigating creating values based on user input.

Edited April 23, 2007 by Guest

[mr_vodka]

Are you looking to do something like this?

timecode.zip

[cbm]

YES! Thanks so much ... this is exactly what I was looking for!