Brian Dunning's FileMaker Custom Functions

TimeAsDecimal ( xTime )

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

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

Michael Bijnens   Michael Bijnens
freelance developer

Share on Facebook Share on Twitter

  Sample input:
TimeAsDecimal ( 01:19:48 )
  Sample output:

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

This custom function converts normal formatted time ( hh:mm:ss ) into decimal time ( x,xx ).
I also developed another convertor ( DecimalAsTime ).



markus schneider   markus schneider, switzerland
May 15, 2014
in the 'define var' - section, the last ';' has to be removed (after 'minutes')
Michael Bijnens   Michael Bijnens, Belgium
May 16, 2014
@ Markus Schneider:

Thanks for the comment.. I have corrected it !
Mr. Pascal Goossens   Mr. Pascal Goossens, Bastogne
Jul 19, 2017
Merci beaucoup, je vais le tester dès demain

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.