Hi all,
Some information is produced at work and I need to pull certain information from it - which I can do but it takes a long time. I am sure some smart person can work something for me to make it so much easier for me.
Below is what we get produced:
What I need pulling is below:
I would really appreciate someones help on this please - Thank you!
Some information is produced at work and I need to pull certain information from it - which I can do but it takes a long time. I am sure some smart person can work something for me to make it so much easier for me.
Below is what we get produced:
John | 00:00 | 07:56 | |
| 07:56 | 12:02 | |
John | 12:02 | 12:36 | |
John | 12:36 | 16:15 | |
John | 16:15 | +00:00 | |
Emma | 00:00 | 09:00 | |
Emma | 09:00 | 17:00 | |
Emma | 17:00 | +00:00 |
What I need pulling is below:
John | Earliest | 07:56 |
John | Latest | 16:15 |
Emma | Earliest | 09:00 |
Emma | Latest | 17:00 |
I would really appreciate someones help on this please - Thank you!