time compare formula

[kksj]

I need a formula that compares the actual time in one cell (=now()) to a set time in another cell, producing a text (for instance: no) in yet another cell when the actual time is less (earlier) than the set time and another text (for instance: yes) when the actual time is more (later) than the set time.
Can this be done and how?
Who can help me out?

 

[leibale]

you have to devide all your entries by 60, because now they where entered as hour:minutes
do it by writing in one cell the number 60, copy it, and then paste special it with the devide action into all the cells
tell me later if it is ok

 

[kksj]

excellent !!!

that works, real smart
thanx a million!

now, however, I need to have the cell that contains the "=(now())/60" formula to refresh itself automatically every 15 minutes or so.
Is this possible and how?