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
http://www.solucionesfilemaker.com

Share on Facebook Share on Twitter

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

  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.

 

Comments

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

this could be:

hour*60+min+(sec>roundSec)
 
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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.