An unofficial blog that watches Google's attempts to move your operating system online since 2005. Not affiliated with Google.

Send your tips to

February 10, 2007

Google Spreadsheets Adds Time Zone Controls

Google Spreadsheets lets you change the timezone and the locale settings for each spreadsheet.

How to do that? Open a spreadsheet, click on File / Settings and change your timezone and locale settings. Then click "save settings." The changes will propagate to all the collaborators that can edit the spreadsheet. The timezone affects timestamps, revision history dates, and time-related functions like NOW() or TODAY(), while the local settings change the currency or the way numbers are displayed.


  1. nonsense.. why would I need to change the time zone for a file?!?

    I dont see any point..

  2. Maybe you keep track of all Los Angeles Lakers games in Pacific time, but you live in Poland.

    Or you collaborate with someone from a different time zone.

  3. For those interested in having google implement *real* timezone support in the google calendar please visit here and add your voice:

  4. you can try this free online timestamp converter( to get a unix time.