Filter date and time hourly data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Filter date and time hourly data

02-27-2024, 08:10 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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)))

For full hours, the formula returns TRUE, otherwise FALSE. Filter your table by formula column!

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 PM.