What he needs is to subtract the Submit date from the Complete date while accounting for weekends and downtime.
There is a function called networkdays which will do this. Unfortunately, it returns only an integer. So for that first line where the start is on Friday and finish is on Monday, networkdays returns 2.
Last edited by gebobs; 09-29-2014 at 01:30 PM.
|