LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default NETWORKDAYS Formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS formula Susan Excel Worksheet Functions 3 July 30th 08 06:04 PM
NETWORKDAYS formula orquidea Excel Discussion (Misc queries) 5 February 15th 08 07:43 PM
need help with networkdays formula aashishtaneja Excel Worksheet Functions 1 September 5th 07 01:06 PM
Networkdays formula Silvie4 Excel Worksheet Functions 4 June 14th 06 09:14 PM
NETWORKDAYS FORMULA Lichase Excel Worksheet Functions 1 June 9th 05 09:24 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"