Hi,
I have a quality log that records pass fail data. If an item fails there is various different locations it will move to.
These locations are selected via a drop down list in column M.
I would like to automatically record the amount of time each location is selected in the cell.
For example - 'location 1' is selected then a day later 'location 2' is selected. How do I record the time this row spent at 'location 1'? (locations have different names on workbook)
I have a quality log that records pass fail data. If an item fails there is various different locations it will move to.
These locations are selected via a drop down list in column M.
I would like to automatically record the amount of time each location is selected in the cell.
For example - 'location 1' is selected then a day later 'location 2' is selected. How do I record the time this row spent at 'location 1'? (locations have different names on workbook)