GetDuration ( tsStart, tsEnd, DurationType )

Calculates the duration between 2 timestamps in

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

GetDuration ( "9/15/2020 9:00 AM", 9/15/2020 5:00 PM, "hrs" )

Sample output:

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

/*
  Created by Kyle Williams
  Date:  9/12/2020
  briandunning.com cf# 2414
*/

Let([
Type = Lower( DurationType );
seconds = 
	Case( 
		Type = "days" or Type = "d"; 86400;
		Type = "hours" or Type = "hrs" or Type = "hr" or Type = "h"; 3600;
		Type = "minutes" or Type = "min" or Type = "m"; 60
	)
];
Round ( ( tsEnd - tsStart ) / seconds ; 2 )
)

Calculates the duration between 2 timestamps in "Days", "Hours", or "Minutes"... (also, "d", "hrs", "h", "min", "m")

Comments

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

GetDuration ( tsStart, tsEnd, DurationType )

Comments

Support this website.

Support this website.