Brian Dunning's FileMaker Custom Functions

ResourceHours ( JobStartTimestamp ; JobEndTimestamp ; WorkStartTime ; WorkEndTime ; HolidayList )

Works out resource hours for resource planning (Mo - Fr). It also takes a Holiday list.

  Average rating: 4.3 (48 votes) Log in to vote

Software developer   Software developer
Thermogreen
http://www.thermogreen.ch

Share on Facebook Share on Twitter

  Sample input:
ResourceHours(13.8.08 9:00;20.8.08 15:00;7:00;17:00;"14.8.08¶15.8.08")
  Sample output:
36

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

This function can be used for resource calculating. It calculates hours between two Timestamps and does a lot more. It will take your Work hours and only count the hours between those. Also your holidays can be excluded by a list of holidays. The list need to be Proper Dates e.g. "01.08.2008" and not "1.8.08". There is a CF for that.
Weekend are excluded also, this can be modified quite easily.
It outputs a Dezimal number, this also can be changed by a simple modification to the custom function.
Error checking is also implemented. So if an End Date is before a Start Date, this will be ignored.

 

Comments

Vince   Vince, New England
Sep 10, 2013
This fella doesn't seem to work, it always returns a "0", even the example. Perhaps it needs to be rewritten for the newer version of FileMaker.
 

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:

Under construction. Email me your wish list for improvements.