binetht
New Member
- Joined
- Dec 22, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi All,
I have 3 separate dates+times as below.
From these 3 separate cells, I want to find the Latest and Earliest Times.
But when I checked the cell's type, it is 2. I think that means this is a Text type of cell. not a date type cell.
What should I do to find the latest and earliest?
I have 3 separate dates+times as below.
16/12/2020 15:13:41 | 21/12/2020 17:28:50 | 21/12/2020 17:28:55 |
From these 3 separate cells, I want to find the Latest and Earliest Times.
But when I checked the cell's type, it is 2. I think that means this is a Text type of cell. not a date type cell.
What should I do to find the latest and earliest?