+ Reply to Thread
Results 1 to 2 of 2

Formual for mutiple start\end dates for business hours

  1. #1
    Registered User
    Join Date
    04-13-2016
    Location
    canada
    MS-Off Ver
    2010
    Posts
    35

    Formual for mutiple start\end dates for business hours

    Hello,

    Need assistance with Specific formula to calculate ONLY business hours for multiple start/end dates in same row.

    Note : Have formula to calculate single start/end date.

    Business hrs include M- F 9AM -5 PM)

    Please see attached : require formula for Line 9 in attachment
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Formual for mutiple start\end dates for business hours

    Refer attach file. In row 9 hours calculate between start & end date in group of 3. In column "H" we only extended your formula with (+) only cell reference changed.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 01-31-2016, 10:14 AM
  2. [SOLVED] Calculating working hours between two dates and business hours
    By mangesh in forum Excel General
    Replies: 3
    Last Post: 06-08-2015, 03:02 AM
  3. [SOLVED] Adding hours to start time - Business hours/holidays/weekends
    By Thunderer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 01:09 PM
  4. Turnaround Time, Including saturdays, start times outside business hours.
    By alexi_987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-15-2012, 07:00 PM
  5. Replies: 0
    Last Post: 04-07-2011, 01:46 AM
  6. Replies: 6
    Last Post: 03-25-2010, 07:50 AM
  7. Calculating Business Hours Between 2 Dates
    By tanya216 in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 10:30 AM

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