smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In column A (A1:A600) I have a dates and time in format dd.mm.yyyy - hh:mm (example. 07.10.2019 - 21:00).
Somehow I need to find an 'average' date for all those dates in column A (split data/dates in column A into two parts) and then to assign an index to each date (column A) according to the half it belongs.
If date from column A is in first half then index '1st', if in second index '2nd'.
All results should be in column B.
example.
<tbody>
</tbody>
In column A (A1:A600) I have a dates and time in format dd.mm.yyyy - hh:mm (example. 07.10.2019 - 21:00).
Somehow I need to find an 'average' date for all those dates in column A (split data/dates in column A into two parts) and then to assign an index to each date (column A) according to the half it belongs.
If date from column A is in first half then index '1st', if in second index '2nd'.
All results should be in column B.
example.
A | B | |
1 | 06.10.2019 - 22:15 | 1st |
2 | 07.10.2019 - 21:00 | 1st |
3 | 07.10.2019 - 22:00 | 1st |
4 | 08.10.2019 - 22:00 | 2nd |
5 | 09.10.2019 - 14:00 | 2nd |
6 | 10.10.2019 - 17:00 | 2nd |
7 | 05.10.2019 - 18:00 | 1st |
8 | 10.10.2019 - 17:45 | 2nd |
<tbody>
</tbody>