Results 1 to 4 of 4

Elapsed working hours, without counting weekends or non-working hours

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    NZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Elapsed working hours, without counting weekends or non-working hours

    Hi Excel wizzes,

    Amazing resource you have here on this forum.

    I was hoping someone could assist me with calculating elapsed hours - taking into consideration working hours and (non-working) weekends.

    Please see the example spreadsheet attached. I was trying to use a formula provided in a similar post, which works perfectly over weekends but doesn't work over non-working hours.

    Thank you very much.

    PS, I hope this works as I have never used a forum before!
    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. Calculating Elapsed Time within Variable Working Hours
    By TIAL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2013, 09:17 PM
  2. Replies: 2
    Last Post: 06-14-2013, 10:45 AM
  3. [SOLVED] Calculating elapsed time,respecting working hours.
    By CoryX in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-10-2013, 04:13 PM
  4. Replies: 7
    Last Post: 07-25-2012, 09:14 AM
  5. Replies: 6
    Last Post: 06-21-2012, 09:59 AM

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