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 - Show more from this author
360Works
http://360works.com

Sample input:

timeParse24 ( "1234" )

Sample output:

12:34

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

Let ( 
  [
    s = Filter ( timeInput ; "0123456789" ) ;
    len = Length ( s ) ;
    hours = GetAsNumber ( Left ( s ;  Case ( len = 3 ; 1 ; 2 ) ) ) ;
    minutes = Case ( len  ≤ 2 ; 0 ; GetAsNumber ( Right ( s ; 2 ) ) )
  ] ;
  Case (
    len = 0 ;
      "" ; // empty input
    hours  ≥ 24 or minutes  ≥ 60 or len > 4 ; 
      "?" ; // invalid
    time ( hours ; minutes ; 0 )
  )
)

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

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

timeParse24 ( timeInput )

Comments

Support this website.

Support this website.