Results 1 to 3 of 3

NETWORK DAYS and TIME calculation help

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    Oxford
    MS-Off Ver
    Excel 2010
    Posts
    57

    NETWORK DAYS and TIME calculation help

    Hi

    I am trying to use NETWORKDAYS to calculate whether 2 dates and times (4 cells) are more than 6 hours apart from one another but my formula shows everything as FAILED

    I've attached the worksheet and below the explanation of how the formula needs to work

    The SLA for urgent codes is 6HTAT (6 Hour Turn Around Time), however the shift pattern is 4.45am – 2.30am so if we receive a request between the times of 2.30 am – 4.45am (non operational hours) – then the 6H TAT should NOT start until 4.45am

    Very confusing I know any help would be much appreciated

    Thanks

    Dan_B
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Working days calculation with Time stamp
    By karthik premkumar in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-19-2015, 05:22 AM
  2. [SOLVED] Need help with time calculation that MAY span multiple days
    By greatscott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2014, 04:25 PM
  3. [SOLVED] Calculation of days between days and time
    By theprincesunil in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-27-2014, 03:09 PM
  4. network days
    By fentiger79 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 04:54 PM
  5. [SOLVED] Subtracting Hold Days from Network Days Formula
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2012, 08:30 AM
  6. time difference calculation between days
    By astrosrini in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-25-2012, 06:47 AM
  7. Network days
    By fithawk in forum Excel General
    Replies: 13
    Last Post: 11-05-2011, 06:17 PM

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