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.