n 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
Here I have given the file download link
https://docs.google.com/open?id=0B9cyU-yp0WgvbmtRNEN5TVNrOTQ
Thank U
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
Here I have given the file download link
https://docs.google.com/open?id=0B9cyU-yp0WgvbmtRNEN5TVNrOTQ
Thank U