Update Google Sheet Time Zone

[user3464]

Hi there!
It looks like the time stamp in the spreadsheet is about 6 hours ahead of time. We are located in the Los Angeles PST time zone.

It would be great if we could choose the time zone in the widget settings.

[Max]

Hi there @user3464

The time in Google Sheets is displayed in UTC. To display the time in your time zone, you should follow these steps:

Open Google Sheets and create a new column (for example, Date with timezone)

Insert the formula into the second line: =DATE(YEAR(F2), MONTH(F2), DAY(F2)) + TIME(HOUR(F2) + 6, MINUTE(F2), SECOND(F2))

Click on the corner of the cell and stretch it to the cell where the formula is needed