I am working with a time study program that allows me to export the information I gather into excel. The Problem is that the software displays the content in such a way that it is difficult to populate the proper template i created with the information it needs. Below is a image showing the information I need. the time information contained in the rows for the unloading staging cycle need to be copied from this document and placed in a column on my template.
06.jpg
the problem is that there are rows with information that i do need in parts of the template but not in the same column as the unloading time information.
05.jpg
Is there a formula that will allow me to grab what I need and leave the rest?
Bookmarks