QuarterHrs ( Timestamp )

Return timestamp quarter hours without sec.

Average rating: 4.1 (15 votes) Log in to vote

Omelyan Burtnyk - Show more from this author
Go To Logistics
https://gotologistics.net

Sample input:

QuarterHrs ( 6/27/2016 4:39:23 AM )

Sample output:

6/27/2016 4:45 AM

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

Let([	
	D = Get( CurrentDate );
	H = Hour( Get( CurrentTime ));
	M = Minute( Get( CurrentTime ))
	];
 
GetAsTimestamp( GetAsText(	
	Month( D ) & "/" & 
	Day( D ) & "/" & 
	Year( D ) & "   " & 
	If( and ( M > 53; M  ≤  59 ); H + 1; H ) & ":" & (
	Minute(
		Case (
			M > 53; 0;
			M > 37; + 2700;
			M > 22; + 1800;	
			M > 7; + 900;
			M >= 0; 0
			)
	))))
)

The number of hours worked by non-exempt employees are calculated using the quarter-hour rounding method.

Comments

		comment, VR Jul 2, 2016
1. This requires that the date format in use is m/d/yyyy. 2. This seems to be a duplicate of: http://www.briandunning.com/cf/1914 As I mentioned there, you only need to do: Round ( timestamp / 900 ; 0 ) * 900

		Omelyan Burtnyk, Go To Logistics Jul 2, 2016
I'm sorry it's realy duplicate I was not sure it's commited Thanks for your comment Mr. VM I think you meant: GetAsTime ( Round ( Get ( CurrentTime ) / 900 ; 0 ) * 900 ) because Timestamp function has 2 parameters date and time Timestamp ( date ; time )

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

QuarterHrs ( Timestamp )

Comments

Support this website.

Support this website.