Try this
Cell A1: 10/01/2020 23:30:00
VBA Code:=IF(VALUE(A1)>VALUE(NOW()), "Not passed", "Passed")
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 04/12/2020 14:41:00 | Not passed | |||
2 | 04/12/2020 14:39:00 | Passed | |||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C2 | C1 | =IF(A1>=(DATEVALUE("04/12/2020")+TIMEVALUE("14:40")), "Not passed", "Passed") |
Post a sample of your data using the board XL2BB app and describe exactly what you are trying to do.I meant row*