IF condition with System time

[Netaji]

Hi,

I want to create a logic with system time

=if(time>(10:30,0,0),"10:30 am shift started","")

It is not working.Can any expert help me to solve it?

Netaji

[Jonmo1]

Try

=IF(MOD(NOW(),1)>TIME(10,30,0),"10:30 am shift started","")

[Netaji]

Hi Jonmo,

Thanks for reply.It works if the i set the (past) time in the formula,If i set the time in future,Say for instance 2 minutes from now..It is not working.My calculation mode is set to automatic only in formula menu.

[Jonmo1]

The formula will only recalculate when a calculation event is triggered (when something on the sheet changes)
It won't change if you just watch it waiting for it to change.

You can press F9 to force a recalculation.

[Netaji]

Thanks a Lot Jonmo.It works now exactly.Thanks again for opening my third eye.lol.

Regards,

Netaji

[Jonmo1]

You're welcome.