Good day, all,
I'm newbie on Excel and would like to ask for your help here.
I tried the formula (MIN IF) and success with first login of the day but doesn't success with logout time by MAX IF.
I have a table as below (Date & Time, Username)
Date and Time Name User ID Date Time
1/1/2018 20:52:02 Nancy 9 1/1/2018 8:52:02 PM
1/2/2018 07:29:15 Tuyet 10 1/2/2018 7:29:15 AM
1/2/2018 07:58:53 thuy 12 1/2/2018 7:58:53 AM
1/2/2018 08:13:08 Rose 26 1/2/2018 8:13:08 AM
1/2/2018 08:26:29 Nancy 9 1/2/2018 8:26:29 AM
The formula to export the first logon time is:
=MIN(IF($B$2:$B$2388=$I$3,IF(INT($D$2:$D$2388)=$M$1,$D$2:$E$2388,2)))
But the logout formula doesn't work and here is mine formula:
=MAX(IF($B$2:$B$93=I$3,IF(ISNUMBER(SEARCH($M$1,$D$2:$D$93)),$D$2:$D$93)))
or
=MAX(IF($B$2:$B$93=$I$3,IF(INT($D$2:$D$93)=M1,$D$2:$E$93,2)))
Range B2 to B93 is the time log for the 2 - Jan - 2018.
You can reference on the image attach for more details.
Logout Formula.PNG
My matter could be the same request as the topic: https://www.excelforum.com/tips-and-...ployees-2.html
Please help to check and advise. Thank you !
Bookmarks