@HourlyWorkEnd ( workStartTimestamp ; scheduledHours )
A customizable function to precisely calculate the end date and time of scheduled hourly work, excluding lunches, weekends, and holidays.
Be the first to rate this function Log in to vote
Alex Zueiv - Show more from this author
Tashkent https://github.com/zueiv |
or
1/2/2023 1:15 PM
(ignoring lunches and holidays)
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
To exclude holidays, create a table with a date field, populate it with holiday dates several years in advance, and enter the fully qualified field name in the leading section of the CF code.
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.