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.

Under construction. Email me your wish list for improvements.