Hey all. I have a time field where the duration of a film is entered in HH:MM (1:30) format. Sometimes we get films in that just have the minutes listed (90). I'm looking to incorporate a script where the user clicks on the duration time field (as a button) and is presented with a dialog box asking for either the duration minutes in one field, or the hour and minutes duration in another. If the HH:MM is entered then the time is directly entered in to the original field as the user entered it. If minutes have been entered, I want a script to convert the time to HH:MM.

For example, if 1:30 is entered in the duration, it stays as 1:30. If 90 was entered in to the duration, it is converted to 1:30. I want the duration time listed in 24 hour notation.

If you can suggest a better method, I would be open to hearing suggestions.

Thank you!

Have you tried a custom dialog?

Here's a sample; you can use the script with a button and a custom dialog (as in this file), or modify the script to use it as a trigger script for an entry field.

btw, 12 or 24 hr format is not a field option, but a layout formatting option.

DurationEntry.fp7.zip