solfm_timeToMinutes ( )

Function stats

Average user rating
299
320
9999
Support
FileMaker 7.0 +
Date posted
21 January 2012
Version
1
Recursive function
No

Author Info
 Diego D'Alessio (solfilemaker)

5 functions

Average Rating None

author_avatar



 

Function overview

Prototype

solfm_timeToMinutes  ( theTime;   roundSec )


Parameters

theTime  1:23:55


roundSec  45


Description

Tags:  time   minutes  

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

Examples

Sample input

solfm_timeToMinutes(1:23:55;45)


Sample output

84

 

Function code

Let([

hour=GetAsNumber(Hour ( theTime ));
min=GetAsNumber(Minute ( theTime ));
sec= GetAsNumber(Seconds ( theTime ))


];
hour*60+min+(Case (sec>roundSec;1))
)

// ===================================
/*

    This function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/320

    Prototype: solfm_timeToMinutes( theTime; roundSec )
    Function Author: Diego D'Alessio (solfilemaker) (http://www.fmfunctions.com/mid/299)
    Last updated: 21 January 2012
    Version: 1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (32)
Date  (28)
XML  (27)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Interface  (15)
Layout  (15)
Text  (14)
Variables  (13)
Filter  (12)
Layout Objects  (11)
Design  (10)
Array  (8)