Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

TimeFromMinutes ( text )

Input time values driven by minutes instead of hours.

  Average rating: 4.3 (31 votes) Log in to vote

Tony Tanevski - Show more from this author Hi-Voltage http://www.hi-voltage.com.au

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Case( Length(text) <= 2; Time ( 0 ; text ; 0 ); Length(text) = 3; Time ( 0 ; Left(text; 1) ; Middle ( text ; 2 ; 2 ) ); Length(text) = 4; Time ( 0 ; Left(text; 2) ; Middle ( text ; 3 ; 2 ) ); Length(text) >= 5; Time ( Replace ( text ; Length(text)-3 ; 4 ; "" ) ; Left ( Right(text; 4) ; 2 ) ; Right ( text ; 2 ) ); ) Click to copy

This custom function is useful if you want to key in time values that drive from minutes rather than from hours. For example, traditionally if you keyed in 1:30 into a time field, FileMaker will treat it as 1 hour and 30 minutes, whereas with this custom function the value will be treated as 1 minute and 30 seconds.

This custom function is useful for the film industry where they have to key in time codes based on minutes. It is a more convenient way to input data rather than having to key in "00:1:30" … the user can just key in "1:30" and it will be treated as 1 minute 30 seconds.

In order for this to work, you will need to have two fields. The Input field must be a text field and the output field must be a time calculation. The output field will call the custom function and convert the text from the input field into a time value.

You will need to lock access to the output field so that the user cannot enter the field. You then place the output field on top of the input field in the exact same position so it looks like one field (make sure the top field has a background color). When the user clicks the group of fields, they gain access to the input field from the bottom and they key in the time. When they click out of the field, the output field displays the converted value.

You must make sure that you reference the output field and not the input field for any reports or calculations.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: