Search code examples
datetimegoogle-sheetstimestring-formattingnumber-formatting

Google Sheets: Performing IF On Date Time Cells


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?


Solution

  • example:

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

    where A1 is for example:

    12/12/2020 17:33:55