# Update timestamp Google Sheet Integration

**URL:** <https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829>\
**Category:** General Questions\
**Created:** [January 11, 2024, 5:56am UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829 "2024-01-11T05:56:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shawn\_Martin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/shawn_martin/32/6841_2.png) [@Shawn\_Martin](https://community.elfsight.com/u/Shawn_Martin)\
**Post date:** [January 11, 2024, 5:56am UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/1 "2024-01-11T05:56:18Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [January 11, 2024, 12:20pm UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/2 "2024-01-11T12:20:49Z")

</div>

Hi @Shawn_Martin 👋

Could you please specify what app is in question?

---

<div class="post-metadata">

**Author:** ![Shawn\_Martin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/shawn_martin/32/6841_2.png) [@Shawn\_Martin](https://community.elfsight.com/u/Shawn_Martin)\
**Post date:** [January 11, 2024, 1:57pm UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/3 "2024-01-11T13:57:52Z")

</div>

Yes,

Contact & Form Builder.

Shawn Martin  
FanYourLocal

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [January 11, 2024, 2:54pm UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/4 "2024-01-11T14:54:51Z")

</div>

Thank you!

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

---

<div class="post-metadata">

**Author:** ![Shawn\_Martin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/shawn_martin/32/6841_2.png) [@Shawn\_Martin](https://community.elfsight.com/u/Shawn_Martin)\
**Post date:** [January 11, 2024, 3:22pm UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/5 "2024-01-11T15:22:37Z")

</div>

Yes,

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

 ![image0.png](https://us1.discourse-cdn.com/flex020/uploads/elfsight/original/3X/5/6/565fed43d277a83a90514d3c2a4510afda7a8ce7.png)

Shawn Martin  
FanYourLocal

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [January 11, 2024, 3:42pm UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/6 "2024-01-11T15:42:28Z")

</div>

Thank you!

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

---

<div class="post-metadata">

**Author:** ![Max](https://sea2.discourse-cdn.com/flex020/user_avatar/community.elfsight.com/max/32/710_2.png) [@Max](https://community.elfsight.com/u/Max)\
**Post date:** [January 12, 2024, 11:29am UTC](https://community.elfsight.com/t/update-timestamp-google-sheet-integration/36829/8 "2024-01-12T11:29:11Z")

</div>

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)**
>
> ![image](https://us1.discourse-cdn.com/flex020/uploads/elfsight/original/3X/5/4/5441e660909242d4b70e3c082f3d60e1213e92af.png)

  

> **Insert the formula into the second line: =DATE(YEAR(F2), MONTH(F2), DAY(F2)) + TIME(HOUR(F2) + 6, MINUTE(F2), SECOND(F2))**
>
> ![image](https://us1.discourse-cdn.com/flex020/uploads/elfsight/original/3X/6/2/6299ee9d045b38900f3e731e17ad7d939ed9ba94.png)

  

> **Click on the corner of the cell and stretch it to the cell where the formula is needed**
>
> ![image](https://us1.discourse-cdn.com/flex020/uploads/elfsight/original/3X/d/7/d7af2593eda511492d6c6d336f435d4bd7e62e5b.png)
> 
>   
> 
> ![image](https://us1.discourse-cdn.com/flex020/uploads/elfsight/original/3X/f/3/f391ee288b59f532002c59f6e23d78ee5e252805.png)