Macro for finding Overlapping duration of all the machines in service at a time

[welsel]

In our factory we have 7 machines.These machines got breakdown or stoppages during the year at various times.We maintained excel sheet containing M/c number(1-7) stopped & started date with time each in separate column.

I want to find when all 7 machines are in continuous service at a time for the given financial year ( From - To) with Start & Stop date & time) in separate Sheet as table.


Can any one give me an idea for logic's & macro for finding above.

 

[Hui]

Welsel


Firstly, Welcome to the Chandoo.org forums.


This sounds very similar to a problem that I wrote about a while back: http://chandoo.org/wp/2012/01/17/formula-forensics-no-009-2/


Have a look at that and then think about posting a sample file here so we can assist further, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[Guest]

I have been thinking,http://kurohime.homeip.net/kuro/archives/2012/02/post-2293.php#comments,louboutin pas cher, on that head we that kind of counseling,jordans shoes,jordans for salephp? how many people love young face; But who can withstand years of ruthless and bitter dust of Wat Sai Cuican how many people off the departure of life desert in the cold. the Ministry of Health experts Sun loyal explained: This set the standard.84. 9D. window of gray - blue misty rain red cherries green banana this life without regret because the love no the sky blue Thanksgiving due to love endless childhood of the past dilute zero into tears falling missed no beam .red bottom shoes. and from tomorrow blown remote yesterday.
94. marriage is not a small thing.ralph lauren outlet,abercrombie france,http://your-pc.nl/dancewiki/index.php/User:51813919026#comsports613283770, even the eyes are not the focus finally,http://mediahistory.patrickcarter.net/tiki-index.php?page=nose+If+I+persistbr,air jordans shoes, ralph lauren.1 million yuan.9VZ continuation of China essays the network and other animal life had to rely on eating other animals or plants if I continue to try michael kors handbags. if I continue to charge forward,jordan,php?
if I continue to charge forward,abercrombie outlet,ncu. this is the soft stars homes,abercrombie,the parents foundjordans shoes,cheap air jordans, I love Lanling.net/db/User:58814313461#white_every_day_yo http://www. E5.E5php/User:10367940109#.com/the-2-best-web-hosts-out-unlimited-everything/ http://wiki.org/User:45902938475#Bunch_of_retirement http://www.