Brian Dunning's FileMaker Custom Functions

DecimalAsTime ( xDecimal )

Convert decimal time ( x,xx ) into normal formatted time ( hh:mm:ss )

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

Michael Bijnens   Michael Bijnens
freelance developer
/

Share on Facebook Share on Twitter

  Sample input:
DecimalAsTime ( 1,33 )
  Sample output:
01:19:48

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

This custom function converts decimal time ( x,xx ) into normal formatted time ( hh:mm:ss ). This version also converts seconds!

 

Comments

Martin Pineault   Martin Pineault, Quebec
Jul 5, 2017
This function is obsolete. Use Time ( 1,33 ; 0 ; 0 ) = 01:19:48
 

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.