Brian Dunning's FileMaker Custom Functions

QuarterHrs ( Timestamp )

Return timestamp quarter hours without sec.

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

Omelyan Burtnyk   Omelyan Burtnyk - Show more from this author

Share on Facebook Share on Twitter

  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)

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

 

Comments

comment   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   Omelyan Burtnyk
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 )
 

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: