Time Spent Calculation : Excluding Business Hours

[gldurand]

Hi Community, I have searched throughout and found the formula to calculate time spent EXCLUDING NON BUSINESS HOURS AND WEEKENDS.

=(NETWORKDAYS(StartDT,EndDT)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT)*MOD(StartDT,1),StopTime,StartTime)

What I require is to reverse this and calculate time of off hour activity in minutes.

So exclude the minutes worked between 9am - 5pm (Monday to Friday)

Hopefully someone can assist

Thanks

 

[James006]

Hi,

To get the Reverse ...Why don't you go with Total - theformula ....