i have a formula to work out the difference between 2 dates excluding weekends and out of office hours.
However, some start dates are at weekends and the calculation returns a minus date.
can anyone suggest a work around for these dates. so maybe if it starts sunday at 9pm it will only calculation the start time at monday 9am when office opens?
