Brian Dunning's FileMaker Custom Functions

TimeAsDecimal ( xTime )

Returns a time value as a decimal i.e. 1:30 as 1.5

  Average rating: 4.3 (31 votes) Log in to vote

Tony Tanevski   Tony Tanevski
Hi-Voltage
http://www.hi-voltage.com.au

Share on Facebook Share on Twitter

  Sample input:
TimeAsDecimal(1:30)
TimeAsDecimal(1:15)
TimeAsDecimal(1:20)
  Sample output:
1.5
1.25
1.33

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

Returns a time value as a decimal i.e. 1:30 as 1.5

 

Comments

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.