Results 1 to 13 of 13

Subtract two times, exclude weekends

Threaded View

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

    Subtract two times, exclude weekends

    I am looking for a formula that subtracts two times from each other. I do not want Saturday and Sunday to be counted in the calculation.

    I was trying to use networkdays.intl but when the item arrived on saturday at a specific date and time and was done processing on Monday at a specific time and date the calculation showed over 24 hours where it should be under 24 hours. I would love for the formula to be in hours. Good Luck to whoever figures this out as it is not my first post on this.
    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. hour difference between two dates/times, exclude weekends and holidays
    By lamdl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-23-2014, 09:11 PM
  2. Replies: 5
    Last Post: 05-18-2012, 10:24 AM
  3. subtract a delivery date:Date Calculation to exclude weekends
    By Vim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2006, 11:00 AM
  4. [SOLVED] calculation to exclude weekends
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] calculation to exclude weekends
    By Need2Know in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2005, 04:05 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