Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
How do you know which logout records belong to which login record? In your example the USER field has different values too.
Ah, my apologies, that is a typo. Both users should read USER-1