timeFormat ( thetime ; leader )
Formats lots of shorthand text strings as time
Average rating: 3.9 (43 votes) Log in to vote
Longterm Solutions LLC
timeFormat("123" ; 0 )
timeFormat("4p" ; 0 )
timeFormat("3" ; 1 )
timeFormat("3" ; 0 )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
timeFormat will take various text input and format it as time. For example, you can enter any of these: 1, 1a, 9p, 1230, 1230p, 125a, 125p.
Error-checking will reject any extraneous characters and show an error message for input that can't be interpreted as time.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.