Results 1 to 16 of 16

Calculating time overlap

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2015
    Location
    Thailand
    MS-Off Ver
    2010
    Posts
    7

    Calculating time overlap

    Hello!

    I need help with a formula to calculate overlapping observation time. We observe multiple subjects (3 or 4 at one time) but each subject comes in and out of view multiple times throughout the total observation time. I am can not figure out a formula to find out the total time that subject 1 and 2, 1 and 3, 1 and 4, 2 and 3...etc are both observed at the same time.

    I have attached a sample of the times observed...

    Thank you!
    Attached Files Attached Files
    Last edited by T_Dawg; 01-20-2015 at 03:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time overlap %
    By sfire184 in forum Excel General
    Replies: 5
    Last Post: 09-09-2014, 02:23 AM
  2. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  3. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  4. Calculating date/time overlap for multiple equipment
    By rhojjati in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2012, 11:33 AM
  5. Calculating the area where charts overlap?
    By still442 in forum Excel General
    Replies: 0
    Last Post: 01-12-2012, 12:56 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