What was the earliest and what was the latest time of the day we sold a product on 14.04.2015?

[fran180]

Data in Google sheet
What was the earliest and what was the latest time of the day we sold a product on 14.04.2015? Use column A from tab Data and explain how you got to your result.
I Know i can use sorting and filtering to get the answer but I am interested in getting the formula without using helper column for timestamp.

 

[Fluff]

Looks like homework to me.
Have a look at using MINIFS and MAXIFS functions.