View Single Post
 
Old 02-27-2024, 08:10 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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