+ Reply to Thread
Results 1 to 1 of 1

Calculating date/time overlap for multiple equipment

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    florida
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculating date/time overlap for multiple equipment

    Hello every one;
    I am new on this board. first, I want to thank you in advance for all your support. Now to my problem.

    Let's say I have multiple equipment. I calculate down time for each equipment based on date and time of occurrence.
    Each equipment can have more than one down time.
    I need to calculate all overlap down time periods (in minutes),
    • some down times start at the same time but end at different time
      some down times start at different time but end at the same time
      some down times start and end at different times
      down times maybe common among all or some equipment

    need to calculate non overlap times

    I have attached the sample sheet.

    any help is appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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