Marcster
08-17-2016, 08:37 AM
Hi People,
I have a list with headers set to:
Date
RecordID
Time
Identifier
Action
RecordID is unique, i.e.Primary Key
Action is either log-on or log-off
I want to summarise the above so it shows by day, how long an Identifier has been logged in. Columns:
Date
Identifier
Time Spent Logged In
There would be several dates and several Identifiers for each date. A new RecordID is created each time an Identifier logs in or out.
Attached is sample data in Excel. Any help much appreciated.
Thanks,
I have a list with headers set to:
Date
RecordID
Time
Identifier
Action
RecordID is unique, i.e.Primary Key
Action is either log-on or log-off
I want to summarise the above so it shows by day, how long an Identifier has been logged in. Columns:
Date
Identifier
Time Spent Logged In
There would be several dates and several Identifiers for each date. A new RecordID is created each time an Identifier logs in or out.
Attached is sample data in Excel. Any help much appreciated.
Thanks,