Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

Quarter24Hrs ( Timestamp )

Returns Timestamp, rounds time to quarter hour without seconds

  Average rating: 3.9 (20 votes) Log in to vote

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

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

/* *Change the date format, and provides 24 hour *format * *Input: Output: *1/5/2017 7:43:18 AM 05JAN17 07:45 *1/12/2017 11:18:01 AM 12JAN17 11:15 *1/8/2017 8:30:52 PM 08JAN17 20:30 *2/2/2017 12:52:34 AM 02FEB17 01:00 * *Made changes to prevent doubles *http://www.briandunning.com/cf/1915 */ Let ( [ _d = GetAsText( Get( CurrentTimestamp )); _ts = GetAsTime( _d ); _t = GetAsTime( Round( _ts/900; 0 ) * 900 ); _h = If( Length( Hour( _t )) = 1; "0" & Hour( _t ); Hour( _t )); _m = If( Length( Minute( _t )) = 1; "0" & Minute( _t ); Minute( _t )) ] ; GetAsText( If( Length( Day( _d )) = 1; 0 & Day( _d ); Day( _d ))) & Upper( Left( MonthName( _d ); 3 )) & Right( Year( _d ); 2 ) & " " & _h & ":" & _m ) Click to copy

The number of hours worked by non-exempt employees are calculated using the quarter-hour rounding method. This means that an employee’s arrival and departure times are rounded to the closest quarter of the hour when calculating the timesheet. Using 8:00 AM as an example, employees will be paid from 8:00, 8:15, 8:30, 8:45 or 9:00.

 

Comments

		comment, VR Jul 2, 2016
I don't think this works. Anyway, to round a timestamp to the nearest quarter hour, you only need to do: Round ( timestamp / 900 ; 0 ) * 900

		Omelyan Burtnyk, Go To Logistics Jul 2, 2016
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 )

		Omelyan Burtnyk, Go To Logistics Jul 2, 2016
and my example working properly

		Omelyan Burtnyk, Go To Logistics Jan 13, 2017
Made changes to prevent doublings

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 21 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: