Find min and max in date range

[paconovellino]

Hello everyone. I hope everyone is staying safe.

I have the following data and I would like to have a formula that finds the min and max time. If the value is the min or max display that time but if it's not leave the cell balk.

3/5/21 07:02​	3/5/21 09:15​
3/5/21 09:19​	3/5/21 10:03​
3/5/21 10:18​	3/5/21 11:17​
3/5/21 11:18​	3/5/21 13:06​
3/5/21 14:00​	3/5/21 14:04​
3/5/21 14:05​	3/5/21 15:32​
3/5/21 15:32​	3/5/21 15:32​
3/5/21 15:33​	3/5/21 16:01​
4/5/21 10:03​	4/5/21 10:59​
4/5/21 10:59​	4/5/21 10:59​
4/5/21 11:09​	4/5/21 11:37​
4/5/21 11:37​	4/5/21 11:38​
4/5/21 12:05​	4/5/21 12:11​
4/5/21 12:12​	4/5/21 12:14​
4/5/21 12:15​	4/5/21 12:19​
4/5/21 12:19​	4/5/21 12:20​
4/5/21 12:25​	4/5/21 12:38​
4/5/21 12:39​	4/5/21 14:36​
4/5/21 14:37​	4/5/21 14:50​
4/5/21 15:03​	4/5/21 15:41​
4/5/21 15:41​	4/5/21 15:41​
4/5/21 15:42​	4/5/21 16:00​

Thanks

 

[mrshl9898]

Well =MIN and =MAX work with numeric dates. I'm not clear what you are after though, could you provide an example? Also what cells is the data in and will that change?

 

[paconovellino]

Hey! thanks for the answer.
I think that I found a solution and is to use a if before the min/max

thanks