Return max time from next day in straight table

[Anonymous]

Hi

I'm having an issue with a straight table and times.

Basically I have data where agents have a log in time of one day and a log out time of the next day (spanning midnight)

I want to display these side by side in a straight table where I am calculating the log in duration.

The data looks like this:

DATE               USER          TIMESTAMP          CATEGORY

01/08/2018      User-1          18:00:00                 Login

02/08/2018      User-2          06:00:00                 Logout

And I want it to appear as below:

DATE                    USER                    LOGIN TIME                      LOGOUT TIME             Duration

01/08/2018          User-1                    01/08/2018 18:00:00          02/08/2018 06:00:00     12:00:00                             

Can anybody help??

[Gysbert_Wassenaar]

How do you know which logout records belong to which login record? In your example the USER field has different values too.

[Anonymous]

Ah, my apologies, that is a typo. Both users should read USER-1