I have a column in a table that contains the date and time. This is the form
15.06.2020 09:43:24 17.06.2020 08:21:04 18.06.2020 12:11:34
2021-01-21 11:57:34 2021-01-21 11:58:02 2021-01-21 11:58:26
Now I am trying to count specific time periods via COUNTIFS, which unfortunately I am not able to do.
It does not matter if I use
take, it does not produce a result that is correct (either all entries are listed or only 1 or 0.
Any idea how I can solve this with COUNTIFS without splitting the timestamps into two columns since this is a report that updates automatically.