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.
The Architects’ Role
14 hours ago