+ Reply to Thread
Results 1 to 2 of 2

Excel 2008 : Calculate Networkdays & 2 set of business hours

  1. #1
    Registered User
    Join Date
    05-05-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Smile Calculate Networkdays & 2 set of business hours

    Hi, all sifu,
    i have been googling a while and find no near remedy.Hope someone can help.

    The current formula work very well for working business hour. Help need is: I like to include a difference set of business hours for Weekend ie: Sat and Sun.

    =(NETWORKDAYS(A2,B2)-1)*(I$3-I$2)+IF(NETWORKDAYS(B2,B2),MEDIAN(MOD(B2,1),I$3,I$2),I$3)-MEDIAN(NETWORKDAYS(A2,A2)*MOD(A2,1),I$3,I$2)

    A2 = date/time received
    B2 = date/time answered
    I3 = end of business hour (7:00am)
    I2 = start of business hour (10:00pm)
    J2:J4 = Holidays (If require) just add to Networkdays(x,x,j2:j4)

    K2 = Start business hour 9:00 am (Sat and Sun)
    K3 = End business hour 9:00 pm (Sat to Sun)

    is it possible? any help appreciate. Thanks.

  2. #2
    Registered User
    Join Date
    02-04-2014
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Calculate Networkdays & 2 set of business hours

    Hi Moktatin,

    i suggest you replace the networkdays fn with networkdays.intl, and choose your weekend

    BEst regards
    Krishnan
    Last edited by krishnanand; 03-03-2014 at 02:44 AM. Reason: typo error

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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