Get First Datetime and Last datetime

[Sri_phani]

Hi,

I am having a challenge with PowerQuery. I have Activity-wise details, I have to find the Login & Logout from those activities. The first time registered in login and the last time registered is logout within that date. 

I tried with an approach of first grouping the data with Employee name and Date. But that is where I am stuck.

Example: Below is the grouped data and in the same screenshot raw data is there in table.  From this screenshot employee login will be 10/4/2024 3 AM and logout will be 10/4/2024 5 AM.

Sample data -  https://docs.google.com/spreadsheets/d/1gKxpcn6-lXejQt_pIew7irDKvf6yMbdH92YbsgT27zc/edit?usp=sharing

Thanks in advance. 

[Sri_phani]

Thank you very much. It helped. 

[jgeddes · Accepted solution]

Does changing your grouping settings as below get you the result you are looking for?