WorkHours and NetWorkHours are analogous to WorkDays and NetWorkDays except that they compute time in terms of hours taking into effect the gaps caused by non-shift hours, weekend and holidays.
The syntax for the functions are:
WorkHours
WorkHours (Start Date/Time, Number of Hours, Shift Start, Shift End, [Holidays]).
- Start Time is the date/time start of the task,
- Number of hours is the time the tasks is estimated to take
- Start Shift is the shift start time
- End Shift is the shift end time
- Holidays is an optional argument that points to a range of dates containing the holidays
The function returns the completion date/time.
NetWorkHours
NetWorkHours(Start Shift, End Shift, Start Date/Time, End Date/Time, [Holidays])
- Start Shift is the shift start time
- End Shift is the shift end time
- Start Time is the date/time start of the task
- End Time is the date/time of task completion
- Holidays is an optional argument that points to a range of dates containing the holidays.
The function contains the number of hours to complete the task.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks