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.

at

4 comments:

  1. UnknownFebruary 13, 2007 at 2:08 AM

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

    I dont see any point..

    ReplyDelete
  2. Alex ChituFebruary 13, 2007 at 3:26 AM

    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.

    ReplyDelete
  3. ScottOctober 25, 2009 at 5:12 PM

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

    http://www.google.com/support/forum/p/Calendar/thread?tid=659883e8e50d4fd8&hl=en

    ReplyDelete
  4. DomFilkSeptember 19, 2015 at 9:53 PM

    you can try this free online timestamp converter(http://www.online-code.net/unix-timestamp.html) to get a unix time.

    ReplyDelete

Note: Only a member of this blog may post a comment.