Hi all;
I'm trying to figure out how to obtain matching the country and dates as well login/logout time
- Need to match country to fetch first Start Timestamp & last End Timestamp
- to return value of hh:mm AM/PM only from the matching.
Was trying to use this below but cant seems to get the last logout time. However my earlier data has time only but now its combined date and time...
{=IFERROR(IF($G13="OD","OD",IF($G13="RD","RD",IF($G13="Leave","Leave",IF($G13="","",INDEX('Login Data'!$F:$F,MATCH(1,(TRIM('Login Data'!$A:$A)=TRIM($C13))*('Login Data'!$E:$E=$G$2),0)))))),"")}
Bookmarks