Take the tour ×

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
add comment

1 Answer

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.

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
add comment

Your Answer


