#1
|
|||
|
|||
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! |
Tags |
date and time, filter |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bar graph or data bars for an hourly countdown | kx1bn7 | Excel | 1 | 12-19-2023 08:10 AM |
OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
Filter by Time | DPD16 | Excel | 0 | 12-30-2015 06:54 AM |
date & time of last time a recent file was used | pgeorgilas | Word | 1 | 10-31-2014 08:59 AM |
Help Date filter | Herve86 | Outlook | 0 | 05-28-2012 04:43 AM |