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:

=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?

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

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.

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 at 17:32
add comment

Your Answer

 
discard

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.