View Single Post
 
Old 09-29-2014, 09:11 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote