Jump to content
Sign in to follow this  
cbm

video timecode, find records by duration

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 )

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.