Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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:


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?

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Maybe try using this function instead of NOW()



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.


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.

share|improve this answer
that worked perfectly! thanks so much. i had no idea the solution was that simple! –  Andrew Davis Dec 14 '11 at 21:43
The GoogleClock() function no longer works with the New Google Sheets... :-( –  Courtney Mar 28 '14 at 17:32

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

share|improve this answer
Could you add some detail on how to change the recalculating setting? –  Vidar S. Ramdal Mar 30 at 8:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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