Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am currently using the following formula to figure out how long a
request takes to be completed. This formula accounts for time spent in a pending status, which is factored-out of the total. =IF(ISBLANK(D2),B2-C2,D2-C2) B2 = Date and Time issue was resolved C2 = Date and Time issue was opened D2 = Date and Time issue was placed in pending status I need a formula that will factor-out the time after business hours; a NETWORKDAYS formula or something similar that will work with the above formula. Thanks in advance for the assistance. LJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NETWORKDAYS formula | Excel Worksheet Functions | |||
NETWORKDAYS formula | Excel Discussion (Misc queries) | |||
need help with networkdays formula | Excel Worksheet Functions | |||
Networkdays formula | Excel Worksheet Functions | |||
NETWORKDAYS FORMULA | Excel Worksheet Functions |