Finding earliest time, per person, per day

[FurRobotic]

I have a data set with three columns, Name, Date, and Time. There are some Names with 2 or more timestamps on the same day but all I need is the earliest time stamp to report on. Without using a pivot table I was wondering if there was a formula I could use that will be able to tell me the earliest time stamp per name, per day

Cardholder Name	Date	Time
Employee 1	12/1/2021	10:09:26
Employee 1	12/1/2021	18:54:24
Employee 1	12/2/2021	8:53:04

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1	Cardholder Name	Date	Time
2	Employee 1	12/01/2021	10:09:26			Employee 1	12/01/2021	10:09:26
3	Employee 1	12/01/2021	18:54:24			Employee 1	12/02/2021	08:53:04
4	Employee 1	12/02/2021	08:53:04
5
6
Primary

Cell Formulas
Range	Formula
H2:H3	H2	=AGGREGATE(15,6,$C$2:$C$100/($A$2:$A$100=F2)/($B$2:$B$100=G2),1)

 

[FurRobotic]

Thank you! That formula looks like it will work, I was just curious how you generated cells F2 and G2 (the data set I have it around 1500 rows with a large number of employees)

 

[Fluff]

I was just curious how you generated cells F2 and G2

I just typed them in manually.