Forms: How to set up your time zone in Google Sheets

[Max]

Using the Google Sheets integration in our Forms, you may wonder why the time there differs from your time?

The thing is that 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

Faced difficulties or got questions? Drop us a line below this post and we’ll be happy to advise