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 ti...
excel
Formulas and Functions
  • TheAntony's avatar
    TheAntony
    Jul 27, 2020

    Flambert86 , replace the link in cell H2:

    ='1'!$A$17

     

    with:

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

     

TheAntony's avatar
TheAntony
Iron Contributor
Jul 26, 2020

Flambert86 , try this in the conditional formatting:

=NOW()-$H2>=TIME(0,30,0)