4

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?

7

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.

2
  • that worked perfectly! thanks so much. i had no idea the solution was that simple! Dec 14 '11 at 21:43
  • 1
    The GoogleClock() function no longer works with the New Google Sheets... :-(
    – Courtney
    Mar 28 '14 at 17:32
6

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

-1

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

1
  • 2
    Could you add some detail on how to change the recalculating setting? Mar 30 '15 at 8:04
-1

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

1
  • 1
    Welcome to Web Applications. This answer was automatically marked as low quality. Please add a brief explanation of how this formula answers the question.
    – Rubén
    Apr 28 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.