Hello,

I am new here and i would like to ask for some help please!

I have a massive list of data of this format, for around a year
[day/month/year hour:minute:second]. The data was collected from a temperature sensor and are for every 10 minutes. This is what i get in every cell of the date&time column:
[30/09/2023 22:00:00]
[30/09/2023 22:10:00]
[30/09/2023 22:20:00]
[30/09/2023 22:30:00]
...

I am looking for a way to filter only the hourly data. For example:
[30/09/2023 22:00:00]
[30/09/2023 23:00:00]
...etc.

Is there any way someone could help me with that please?

Thank you very much in advance!

Let's assume your data starts from cell A2
Into column next to rightmost of your data enter the formula (on fly):
For full hours, the formula returns TRUE, otherwise FALSE. Filter your table by formula column!

Hi. As working with times and dates can be tricky, post a sample sheet please ( not a picture). Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post