Brian Dunning's FileMaker Custom Functions

timeParse24 ( timeInput )

Converts user-entered 24-hour time to a FileMaker time object, or "?" if input is invalid

  Average rating: 5.0 (1 vote) Log in to vote

Sam Barnum   Sam Barnum
360Works
http://360works.com

Share on Facebook Share on Twitter

  Sample input:
timeParse24 ( "1234" )
  Sample output:
12:34

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

Use this with time inputs as auto-enter calc

timeParse24( Self )

More sample inputs & outputs:

timeParse24 ( "0" ) // 0
timeParse24 ( "9" ) // 9:00
timeParse24 ( "09" ) // 9:00
timeParse24 ( "23" ) // 23:00
timeParse24 ( "24" ) // ?
timeParse24 ( "123" ) // 1:23
timeParse24 ( "123" ) // 1:23
timeParse24 ( "160" ) // ?
timeParse24 ( "2359" ) // 2359
timeParse24 ( "2360" ) // ?
timeParse24 ( "2401" ) // ?
timeParse24 ( "12345" ) // ?

 

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.

Under construction. Email me your wish list for improvements.