Forum Discussion
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
- TheAntonyIron Contributor
- Flambert86Copper 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!- TheAntonyIron Contributor
Flambert86 , can you share a sample of the workbook without any confidential info?