solfm_timeToMinutes ( )
Function stats
Average user rating
Support
FileMaker 7.0 +
Date posted
21 January 2012
Version
1
Recursive function
No
Function overview
Prototype
solfm_timeToMinutes (
theTime; roundSec )
Parameters
theTime 1:23:55
roundSec 45
Description
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
*/
// ===================================
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
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
