Results 1 to 7 of 7

Removing non business days & hours

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2009
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    6

    Removing non business days & hours

    How do I calculate the number of days, hours & minutes between 2 value's and exclude non business days and hours...? For example, I have 2 time/dates stamps; 1. the time/date an incident was logged (say 01/21/09 09:30). 2. the time/date the incident was resolved (say 01/29/09 19:30). In real time thats 7 days & 10 hours. But in business terms its 6 days 2.5 hours (working Monday - Friday, 9 - 5 (8 hr days)).

    I can use 'networkdays' function to calculate working days but it ignores the time completely.

    I'm using Excel 2007

    HELP!!!??


    Cheers, Jason
    Last edited by Shakey; 02-08-2009 at 09:07 PM. Reason: Incorrect version of Excel displayed

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