Google Sheets: Performing IF On Date Time Cells-CodePudding

Home > Back-end > Google Sheets: Performing IF On Date Time Cells

Google Sheets: Performing IF On Date Time Cells

Time：01-13

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?

CodePudding user response：

example:

=IF(TEXT(A1, "hh:mm")="17:34", "x", "y")

where A1 is for example:

12/12/2020 17:33:55

Page link：https//www.codepudding.com/Backend/261359.html

Prev:Highlight multiple rows from a listbox based on two if condition in C#

Next:Python date validation with no input/invalid input

Tags：

Links：
CodePudding