Is there a way to perform an =IF function on a cell in google sheets that determines if the time of the date time cell equals a particular time regardless of date equals a certain value?
example:
=IF(TEXT(A1, "hh:mm")="17:34", "x", "y")
where A1 is for example:
12/12/2020 17:33:55