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.

EDIT:

GOOGLECLOCK is not available in the new Google Sheets. To get the same results, use the NOW function and change your recalculation setting to "On change and every minute" in your spreadsheet at File > Spreadsheet settings.

Answer 2

Google official help file:

• The NOW function can be used to replace the GOOGLECLOCK function, which is not available in the new Google Sheets.
• Apply the NOW function and change your recalculation setting to "On change and every minute" in your spreadsheet at File > Spreadsheet settings.

Source: https://support.google.com/docs/answer/3092981?hl=en

Answer 3

Use =NOW(), then change the recalculating setting of the cell to every minute.

Answer 4

=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))