Forum Discussion

Flambert86's avatar
Flambert86
Copper Contributor
Jul 26, 2020
Solved

Conditional formatting Date/Time in same cell

Hi all,

I have a sheet that pulls timestamp data from multiple sheets. I want to use conditional formatting to tell me if the timestamp is older than 30 minutes. The timestamp contains date and time information in the same cell with a format of "m/d/yyyy, h:mm:ss AM/PM" .

I cannot figure out what formula to use to find dates/times older than 30 minutes. Currently the sheet uses conditional formatting for unique entries but it has some errors.

I have attached a photo of the summary data. This is what it should look like when properly formatted.

Thanks for any help you can provide!

7 Replies

    • Flambert86's avatar
      Flambert86
      Copper Contributor

      Thank you for the quick response. Unfortunately it did not work. Any other thoughts? I attached a new photo of the formula you suggested.

      Thanks!

Resources