#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! |
#2
|
|||
|
|||
Let's assume your data starts from cell A2
Into column next to rightmost of your data enter the formula (on fly): Code:
=(TIME(HOUR($A2),0,0) = ($A2 - TRUNC($A2))) |
#3
|
||||
|
||||
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 |
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 |