AddTimes ( Time1 ; Time2 )

Add two times, in h:mm:ss format, together

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

Bill Thurmes - Show more from this author
MDCA
http://www.miyotadca.com

Sample input:

AddTimes ( "28:35" ; "35:47" )
AddTimes ( "28:13" ; "31:30" )

Sample output:

1:04:22
59:43

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

/*---------------------------------------
# AddTimes ( Time1 ; Time2 )
# Time2 will be added to Time1
# Entry format should be h:mm:ss, or mm:ss, or ss (up to 86400)
# Result will be in same format, dropping unneeded info from left
# Examples: AddTimes ( "28:35" ; "35:47" ) = 1:04:22
# AddTimes ( "28:13" ; "31:30" ) = 59:43
# 2019 changes: Corrected so it worked for :01, de-complicated CF, minor error-trapping
# Bill Thurmes 2014 corrected 3/21/2019
------------------------------------------*/

Let ( [ 
Time1 = Substitute ( Filter ( Time1 ; "0123456789-+:" ) ; "::" ; ":" ) ;
Time2 = Substitute ( Filter ( Time2 ; "0123456789-+:" ) ; "::" ; ":" ) ;
Time1 = Case ( 
		PatternCount ( Time1 ; ":" ) = 2 ; 
		GetAsTime ( Time1 ) ; 
		
		Time1 < 0 and PatternCount ( Time1 ; ":" ) < 2 ;
		GetAsTime ( Evaluate ( Substitute ( Time1 ; ":" ; " * 60 - " ) ) ) ;
		
		PatternCount ( Time1 ; ":" ) < 2 ; 
		GetAsTime ( Evaluate ( Substitute ( Time1 ; ":" ; " * 60 + " ) ) ) 
		) ;
Time2 = Case ( 
		PatternCount ( Time2 ; ":" ) = 2 ; 
		GetAsTime ( Time2 ) ; 
		
		Time2 < 0 and PatternCount ( Time2 ; ":" ) < 2 ;
		GetAsTime ( Evaluate ( Substitute ( Time2 ; ":" ; " * 60 - " ) ) ) ;
		
		PatternCount ( Time2 ; ":" ) = 1 ; 
		GetAsTime ( Evaluate ( Substitute ( Time2 ; ":" ; " * 60 + " ) ) ) 
		) ;
~t = Time1 + Time2 ] ;
~t
)

Time2 will be added to Time1
Entry format should be h:mm:ss, or mm:ss, or ss
Result will be in same format, dropping unneeded info from left.
If you want an h:mm:ss output, just drop the lines after t = Time (... and output t.
Primarily useful if the time format is/might be mm:ss
Changed 4/12/19 to work better

Comments

		comment, VR Apr 10, 2014
Filemaker can add and subtract times natively.

		Bill Thurmes, MDCA Apr 11, 2014
Thanks. I had needed something to add text that was in a mm:ss format, which Filemaker's native time addition doesn't deal with well. I've changed the script to use Filemaker's native capabilities.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

AddTimes ( Time1 ; Time2 )

Comments

Support this website.

Support this website.