+ Reply to Thread
Results 1 to 1 of 1

=Networkdays Help Needed

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    61

    =Networkdays Help Needed

    I am trying to subtract two times from each other using the formula below. I do not want to count Saturday or Sunday and I have found a formula that works perfect when an item arrives Monday thru Friday. But, when the item arrives on Saturday at 5am and is finished processing on Monday at 5pm it says 1 day and 12 hours and when the item arrives on Saturday at 5pm it says 1 day. When the item arrives on the weekend count should stop.

    E13 is start day/time
    M13 is end day/Time
    F13 is start shift time
    N13 is end shift time

    =IF(AND(INT(E13)=INT(M13),NOT(ISNA(MATCH(INT(E13),
    HolidayList,0)))),"0 days 0 hours", IF(INT(E13)=INT(M13),
    "0 days " & ROUND(24*(M13-E13),2)&"hours",
    MAX(NETWORKDAYS(E13+1,M13-1,HolidayList),0)+
    INT(24*(((M13-INT(M13))-(E13-INT(E13)))+
    (N13-F13))/(24*(N13-F13)))&
    " days "&MOD(ROUND(((24*(M13-INT(M13)))-24*F13)+
    (24*N13-(24*(E13-INT(E13)))),2),
    ROUND((24*(N13-F13)),2))&" hours "))
    Last edited by blens1; 02-01-2014 at 09:23 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help with an IF within NETWORKDAYS
    By nabril15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 10:20 AM
  2. Conditional formatting needed for shape colour - is programming needed?
    By Farmboyuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 07:27 AM
  3. Networkdays help
    By ZOONY in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2012, 09:08 PM
  4. Networkdays
    By BobN in forum Excel General
    Replies: 12
    Last Post: 05-25-2011, 05:29 PM
  5. NetWorkDays
    By ClikClak in forum Excel General
    Replies: 4
    Last Post: 03-01-2010, 11:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1