Description
Returns the number of working hours from a time interval.
Parameters
Return Type
Number
The returned number represents the working hours from the given time interval.
Example
number hours;
date startDate = "2012-01-10 12:00:00";
date endDate = "2012-01-20 10:30:00";
string startHour = "09:00";
string endHour = "17:00";
number[] weekend = {7, 1};
date[] holidays = {"2012-01-18", "2012-01-16"};
hours = getWorkingInterval(startDate, endDate, startHour, endHour, weekend, holidays);
Returns the number of working hours from 2012-01-10 12:00 to 2012-01-20 10:30, excluding the weekends (7 is Saturday and 1 is Sunday) and holidays (2012-01-18 and 2012-01-16).
See also
We've encountered an issue exporting this macro. Please try exporting this page again later.