Results 1 to 5 of 5

Overlapping Time Based on Conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2017
    Location
    columbus, ohio
    MS-Off Ver
    Office 2010
    Posts
    2

    Overlapping Time Based on Conditions

    I have a report showing when an error light is above a set of conveyors. I want to figure out how much time a group of conveyors is down.

    Lane 1 and 2 are run by Team 1
    Lane 3 and 4 are run by Team 2
    Lane 5 and 6 are run by Team 3
    ....
    Lane 15 and 16 are run by Team 8
    ....
    Lane 23 and 24 are run by Team 12

    What I want to know, is for what length of time does each team have an error on both of their conveyors.

    Capture.PNG

    In the example I highlighted, Lane 5 and 6 both have error lights which overlap by 1.433 minutes.
    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. [SOLVED] Calculating # of Overlapping days with several date ranges and conditions
    By ZafferAhmed in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-30-2021, 05:44 AM
  2. [SOLVED] Sum time spent based on conditions
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-02-2015, 05:43 AM
  3. Replies: 1
    Last Post: 11-14-2013, 08:45 AM
  4. Count based on date/time conditions
    By lrmorales87 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2012, 01:08 AM
  5. Replies: 1
    Last Post: 10-30-2012, 07:12 PM
  6. [SOLVED] Formula based upon time data with conditions
    By halfpint123 in forum Excel General
    Replies: 4
    Last Post: 09-28-2012, 12:41 PM
  7. Counting Overlapping Time & Non-Overlapping Time
    By I_need_help1 in forum Excel General
    Replies: 4
    Last Post: 02-08-2011, 02:36 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