Results 1 to 13 of 13

Subtract two times, exclude weekends

Threaded View

  1. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Subtract two times, exclude weekends

    My proposition:
    =NETWORKDAYS.INTL(MAX(A6,WORKDAY.INTL(A6-1,1,1)),B6,1)-MOD(MAX(A6,WORKDAY.INTL(A6-1,1,1)),1)+MOD(B6,1)

    And format for instance as [hh]:mm
    Please note that in last row you will get negative number, because as opposite to " I do not want Saturday and Sunday ..." the arrival is on Sat and processed on Sunday :-(

    Using NETWORKDAYS.INTL is a good idea because it allows to easily take into account holidays.

    if you want to have it as a number of hours take
    =(the formula_above)*24
    and use general format
    Attached Files Attached Files
    Best Regards,

    Kaper

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. [SOLVED] 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. 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