Brian Dunning's FileMaker Custom Functions

solfm_timeToMinutes ( theTime ; roundSec )

Converts time (HHMMSS) to Minutes

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

Diego DAlessio   Diego DAlessio
Soluciones Filemaker

Share on Facebook Share on Twitter

  Sample input:
solfm_timeToMinutes (1:23:55;45)
  Sample output:

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

Converts HHMMSS to time, you can pass a parameter to determinate how many seconds round up to add a minute.



Raybaudi   Raybaudi, Rome
Jan 21, 2012
hour*60+min+(Case (sec>roundSec;1))

this could be:

comment   comment, VR
Jan 22, 2012
Why not simply -

time / 60

This is a decimal number that can be rounded using any one of the conventional methods.

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.