Brian Dunning's FileMaker Custom Functions

rapidTimeEntry ( text ; workdayStartHour )

enter time with numbers only

  Average rating: 4.2 (27 votes) Log in to vote

David Schellenberg   David Schellenberg
Rivet Design
http://www.rivetcom.ca

Share on Facebook Share on Twitter

  Sample input:
rapidTimeEntry ( "1323 ; 7 )
rapidTimeEntry ( "655 ; 7 )
rapidTimeEntry ( "1005 ; 7 )
  Sample output:
1:23 PM
6:55 PM
10:05 AM

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

- convert a string of numbers (no punctuation) to time.
- AM/PM is determined by Workday Starting Hour.
- opening IF statement will allow the user to modify the result.

- currently function only considers a workdayStartHour less then 12

 

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.