Brian Dunning's FileMaker Custom Functions

TimeFormatAsText ( theTime )

Formats a valid time value to be written out in long form with the words for how many

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

Jonathan Mickelson   Jonathan Mickelson

Share on Facebook Share on Twitter

  Sample input:
TimeFormatAsText ( GetAsTime ("1:27:02") )
  Sample output:
1 hour, 27 minutes and 2 seconds

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

Formats a valid time value to be written out in long form with the words for how many "hours, minutes and seconds" the time value is. The output is in a format suited for duration rather than a time of day.

 

Comments

Bruce Robertson   Bruce Robertson
Nov 23, 2017
Why is the example input RectangleArea ( 2 , 3 )?
Why is the example output 6?
 
Jonathan Mickelson   Jonathan Mickelson
Nov 25, 2017
Thanks for pointing that out Bruce, I missed some of the form fields when submitting it. It's been corrected, with a real example.
 

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.