Forum Discussion

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 ti...

excel

Formulas and Functions

TheAntony
Jul 28, 2020
Flambert86 , replace the link in cell H2:
='1'!$A$17

with:
=DATEVALUE(SUBSTITUTE('1'!$A$17,",",""))

Flambert86

Copper Contributor

Jul 27, 2020

You are correct. They are text that is being pasted into the numbered sheets from a data source. The summary page pulls that information from the other sheets so each cell in the summary is actually a link to another cell in a seperate sheet.

In order for this to work the way it needs to, finding and replacing the comma each time is not feasable.

Is there another way to get it to recognize this as a date/time format?

TheAntony

Iron Contributor

Jul 28, 2020

Flambert86 , replace the link in cell H2:

='1'!$A$17

with:

=DATEVALUE(SUBSTITUTE('1'!$A$17,",",""))