Hi,

I put the below formula in the cell A1, i need to refresh it every one
second so that it might look like a clock, can anybody help?

=NOW()