I have a table with 5 columns:
Date - LoginID - Exception - Start - Stop
I have attached an example of the data.
What I am trying to achieve is to convert this table into a usable format for another system to do this I need to do several things.
First I need roll up all the instances of "Open Time" in the "Exception" field so that per day, per ID there is only 1 entry remaining which shows the minimum value found in "Start" and the maximum value found in "Stop" as the other system only logs "Open Time" as 1 entry as opposed to a breakdown of each segment in the table I have provided.
I also need to split the breaks in the table into 2 separate Breaks using minimum value from "Start" and minimum value from "Stop" to get first break and the same again but with maximum values to get the second break.
I am running a complete blank and have tried various methods to no avail.
I would be forever grateful if someone could take some time to either solve this problem or point me in the right direction as I have not been able to find what I need by searching the forum.
Many thanks.
Bookmarks