Quote:
Originally Posted by spamdavy
Hello there,
I am stuck trying to figure out whether a list of users have logged in within a specific 24 hour timeframe defined relative to their initial login time.
In the attached spreadsheet:
A-first login - user ID
B-login timestamp - the day and time when that user first logged in
C-24 hr period - 24 hours after the first login
D-48 hr period - 48 hours after the first login
The idea is to figure out whether the users in Column H have re-logged in between 24 and 48 hours after their first login. The same user could have logged in multiple times but I only care if that person has at least one login instance that satisfy the criteria.
I greatly appreciate any insight into which Excel functions might help me solve this riddle.
Thank you in advance!
davy
|
Hi Davy,
I'm not sure I've fully understood your requirement, but I've had a go at what I
think you mean. Hopefully it will give you a starting point at least.
I've added formulas to columns E & F that will show a 1 if the first relevant re-login timestamp in column I falls within 24 hours of initial login (column E) or 48 hours of initial login (column F).
There is only one matching login ID so you only get one result.
Is this anywhere near what you were after?
S.