Filtering data

[sumsaam]

12-03-2023.xlsx
	A	B	C	D
1	Emp ID	First Name	Date	Time
2	1	Sumsaam	01-03-2023	20:45
3	1	Sumsaam	01-03-2023	22:06
4	1	Sumsaam	02-03-2023	16:41
5	1	Sumsaam	02-03-2023	21:50
6	1	Sumsaam	02-03-2023	22:07
7	1	Sumsaam	04-03-2023	13:38
8	1	Sumsaam	04-03-2023	22:06
9	3	Mustafa	01-03-2023	11:09
10	3	Mustafa	01-03-2023	22:06
11	3	Mustafa	02-03-2023	11:08
12	3	Mustafa	02-03-2023	22:07
13	3	Mustafa	03-03-2023	15:37
14	3	Mustafa	03-03-2023	22:02
15	3	Mustafa	04-03-2023	11:07
16	3	Mustafa	04-03-2023	22:06
17	4	Afaq	02-03-2023	11:09
18	4	Afaq	02-03-2023	22:07
19	4	Afaq	03-03-2023	15:03
20	4	Afaq	03-03-2023	22:02
21	4	Afaq	04-03-2023	11:07
22	4	Afaq	04-03-2023	22:07
Sheet

I want a formula that checks id,Name and date then reutrns the time of that employee. and and if an employee had two times in same date then how to differentiate that.

 

[Fluff]

Duplicate to: Formula for filtering data required

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.