Results 1 to 1 of 1

Help Me Using Networkday for Counting SLA

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2011
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help Me Using Networkday for Counting SLA

    Dear All,

    Kinda have problem with counting time between date.
    I really need to count time between submit date and resolved date but excluding weekend.
    Problem is I never get a constant result with all reference in the other thread.
    I always get some error in some row.
    For Example :

    9/22/2011 15:21 9/23/2011 10:20 2.98
    I used = (NETWORKDAYS(A14,B14)*$J$2) + (($I$2- MOD($A14,1))-($I$2-MOD($B14,1)))*24 - ((MOD(A14,1)>MOD(B14,1))*8)

    Reference :
    I2,J2
    Day End Hours per day
    17:00 8

    I used Excel 2011.
    Can somebody help me with this ...
    So desperate ...

    I attached somedata from worksheet
    Really appreciated for any response
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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