Consolidating and converting table data - Help!

[forbzinator]

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.

[AlanY]

you have forgotten to attach an example of data

[forbzinator]

I can't seem to find an option to add a file from the menu? I will recreate the table in a post in a few minutes. Thanks for letting me know

[StephenR]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic