Brian Dunning's FileMaker Custom Functions

TimeAsDecimal ( xTime )

Convert time into decimal

  Average rating: 4.2 (26 votes) Log in to vote

Tony Tanevski   Tony Tanevski
Hi-Voltage Melbourne

Share on Facebook Share on Twitter

  Sample input:
TimeAsDecimal ( 2:30 )
  Sample output:

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

Convert hours into decimal

Tony Tanevski
Hi-Voltage, Melbourne Australia



Bernard Moreau   Bernard Moreau, Borchtlombeek, Belgium.
Oct 26, 2015
Hour(xTime) + Minute(xTime) / 60
should work too, isn't it ?
comment   comment, VR
Oct 28, 2015
Or simply:

Time / 3600
Tony Tanevski   Tony Tanevski, Melbourne
Oct 28, 2015
Time / 3600 does work, but needs to be rounded as it can return multiple decimal places. i.e. 1:24:53s returns 1.4147222222222222

Whereas my function disregards the seconds completely - it just depends on whether you want to include seconds or not.
comment   comment, VR
Oct 28, 2015
Well, using your calculation, 00:01:00 will return 0.0166666666666667. Ignoring the seconds has nothing with this - all it accomplishes is making the calculation more complicated and the result less precise.
Tony Tanevski   Tony Tanevski, Melbourne
Oct 28, 2015
Yes you are right :)
Thomas Hellwig   Thomas Hellwig, Germany
Dec 26, 2015
So why don't you delete the wrong CF "round(xTime / 3600, 2)"?
Tony Tanevski   Tony Tanevski, Melbourne, Australia
Dec 26, 2015
No need to delete the custom function as it has been corrected.

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.