How to have auto updated current time cell in GoogleDocs / Excel

Question

I am trying to create a spreadsheet that will allow me to track my clients' timezones.

I am using the useless NOW() function to calc current time, and then factor in the time zone value (+/- a #) as so:

=NOW()+(E2)*TIME(1,0,0)

But the cells dont update when I refresh. They just stay at whatever time was calculated or recalculated.

How can I get the current time to recalculate when I refresh the page so that all the times will be accurate?

Is there an HTML solution for this that I could use instead?

Answer 1

Maybe try using this function instead of NOW()

=GoogleClock()

GoogleClock()

Returns the current date and time according to your computer system. Updates automatically each minute on the minute (unlike the NOW function). No arguments are used in this function.