I assumed that NOW() in a cell (say A1) would produce a constantly changing field, so if formatted as hh:mm:ss it would show the time changing.
Similarly if I enter SECOND(A1) in another cell it should show the seconds constantly counting up from 0 to 59, over and over.
What happens is that values appear in the fields but they don't change unless I refresh the screen manually in one way or another.
I have Calculation set to Automatic.
A friend does the same thing and his times are constantly changing but we can't see what the difference is between our settings.
Any suggestions please ? I'm trying to develop something which needs the time to be changing and can't even get to first base !
Thanks in advance
tgmjf
Bookmarks