Forum Discussion
If now()
Hi I would like to make a formula with conditions: if the time now is greater than 1 pm show cell A2 but if it is later than 1pm show B2 I have tried the below but cannot work out why it is ...
TKelly445 you can use a variation of SergeiBaklan and use 13.5/24 instead of 13. Or the following if that it more readable for you:
=IF(MOD(NOW(),1)*24 > --"1:30 PM", A2, B2)