Update timestamp Google Sheet Integration

[Shawn_Martin]

Hi,

Wondering if you can get the timestamp to match the timestamp of my or my clients time zone in Google Sheets Integration. Seems it’s off by 6 hours from my time zone.

Thank you!

[Max]

Hi @Shawn_Martin

Could you please specify what app is in question?

[Shawn_Martin]

Yes,

Contact & Form Builder.

Shawn Martin
FanYourLocal

[Max]

Thank you!

To make things clear, could you please share a screenshot of the timestamp you mean?

[Shawn_Martin]

Yes,

I ran the last demo at 8:26:58 not 14:26:58 as it shows.

Shawn Martin
FanYourLocal

[Max]

Thank you!

I’ll check it with our devs and will get back to you a bit later

[Max]

Hi @Shawn_Martin

It seems that 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