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 - Show more from this author

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.