View Single Post
 
Old 02-27-2024, 04:48 AM
konmad konmad is offline Windows 10 Office 2021
Novice
 
Join Date: Feb 2024
Posts: 1
konmad is on a distinguished road
Unhappy Filter date and time hourly data

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!
Reply With Quote