Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

FormatAsTime ( ~time )

To type in times more easily use this CF in the auto enter calculation of a time field.

  Be the first to rate this function Log in to vote

Udo Bösch - Show more from this author Udo R. Bösch mipiano apps http://mipiano.de

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

/* Typing times into time fields is cumbersome: ##:##:## With this custom function, you only need to enter the numbers. Without colons and leading zeros before the first number. For entering 4 minutes and 25 seconds just type 425. The CF gives back 00:04:25. Call this CF in the auto enter calculation of a time field and make sure to uncheck "Do not replace existing field value". */ Let ( [ ~time = Substitute( ~time ; ":" ; "" ); ~lengthOf~time = Length( ~time ); ~lengthOfTimeString = If( ~lengthOf~time ≤ 6 ; 6 ; ~lengthOf~time ); ~timeWithLeadingZeros = Right ( "0000000000" & ~time ; ~lengthOfTimeString ); ~hours = Left ( ~timeWithLeadingZeros ; ~lengthOfTimeString -4 ); ~minutes = Middle ( ~timeWithLeadingZeros ; ~lengthOfTimeString -3 ; 2 ); ~seconds = Right ( ~timeWithLeadingZeros ; 2 ); ~validateInput = If ( GetAsNumber ( ~hours ) < 24 and GetAsNumber ( ~minutes ) < 60 and GetAsNumber ( ~seconds ) < 60 ; True ; False ); ~timeFormatted = ~hours & ":" & ~minutes & ":" & ~seconds; ~end = ""]; // Calculation If ( ~validateInput ; ~timeFormatted ; "?") ) Click to copy

Typing times into time fields is cumbersome: ##:##:##

With this custom function, you only need to enter the numbers. Without colons and leading zeros before the first number.

For entering 4 minutes and 25 seconds just type 425. The CF gives back 00:04:25.

Call this CF in the auto enter calculation of a time field and make sure to uncheck "Do not replace existing field value".

 

Comments

		Bluebird, privat Mar 3, 2021
It's very nice.

		Udo Bösch, Udo R. Bösch mipiano apps Mar 3, 2021
Thank you!

		Udo Bösch, Udo R. Bösch mipiano apps Mar 3, 2021
The has been a mistake in the function. Now it should work properly. (2021-03-04)

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: