paconovellino
New Member
- Joined
- Sep 17, 2013
- Messages
- 27
- Office Version
- 365
- 2019
- Platform
- MacOS
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.
Thanks
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