Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-27-2024, 04:48 AM
konmad konmad is offline Filter date and time hourly data Windows 10 Filter date and time hourly data Office 2021
Novice
Filter date and time hourly data
 
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
 

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
Filter date and time hourly data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft