Brian Dunning's FileMaker Custom Functions

TimeCorrect ( TimeEntry )

Enter time in a time field with or without colons (:) and convert to valid time

  Average rating: 4.3 (6 votes) Log in to vote

Menno van Beek   Menno van Beek
Van Beek Zakelijke Software
https://www.vbzs.nl

Share on Facebook Share on Twitter

  Sample input:
TimeCorrect ( 023 )
TimeCorrect ( 15 )
TimeCorrect ( 537 )
TimeCorrect ( 11:15:30 )
TimeCorrect ( 1630 )
TimeCorrect ( 8 )
TimeCorrect ( 34:30 )
  Sample output:
0:23:00
15:00:00
5:37:00
11:15:30
16:30:00
8:00:00
10:30:00

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

Very simple function to give users the ability to enter times like 925 instead of 9:25. This can be used in script or as auto-entry option in a time field or in calculations and scripts.

 

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.