# Google Calendar integration **URL:** \ **Category:** Ask for Help\ **Created:** [April 17, 2023, 4:08pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629 "2023-04-17T16:08:59Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 17, 2023, 4:08pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/1 "2023-04-17T16:08:59Z")
The google calendar integration does not work 100%. I am not able to block for example 2 days from 17 - 18th when I use the 17th as start and 1 day as duration. (Durations brocken down in minutes) Those three images show the problem. The calendar ads 2 hours and I dont know why… and it does not work to block one full day, when I add just 24 hours as the duration… do you have an idea? ![Bildschirm­foto 2023-04-17 um 18.06.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/8586e04a8ca199821b3a1bde134f095756c7c4f6.png) ![Bildschirm­foto 2023-04-17 um 18.06.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/62f8199eb9c12fc880a4dc0c66d81989e6dca754.png) ![Bildschirm­foto 2023-04-17 um 18.06.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/3109d458681c53403d890c150a359209648131eb.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 18, 2023, 1:17am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/2 "2023-04-18T01:17:14Z")
![Bildschirm­foto 2023-04-17 um 18.06.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/62f8199eb9c12fc880a4dc0c66d81989e6dca754.png) So which column here is your “start” column? I assume the first one? Based on that screenshot, are you trying to block from 17 April at 6AM to 18 April at 6PM? ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 18, 2023, 6:38am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/3 "2023-04-18T06:38:09Z")
@ThinhDinh I tried several things but YES, the 17 april is my start date… this is the one which is selected in the screenshot… When it is used it will be 17th and 2 am… when the next colume is used, it will be 17 8 am… so its adding 2 hours and I dont understand why… but the main problem is the duration… so its not possible for me to add one full day for example ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 19, 2023, 12:32am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/4 "2023-04-19T00:32:48Z")
What timezone are you in? Is your “start date” column’s “respect timezone” option turned on? ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 19, 2023, 6:52am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/5 "2023-04-19T06:52:04Z")
yes, it is turned on. I am mittle of europe… (CEST) ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 19, 2023, 6:52am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/6 "2023-04-19T06:52:12Z")
@ThinhDinh ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 19, 2023, 11:36pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/7 "2023-04-19T23:36:19Z")
It does sound almost like Glide is taking your timestamp as GMT, then tries to convert it to CEST when it goes to Google Calendar (that’s possibly why it added 2 hours). I’ll let the team know about this. ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 20, 2023, 5:55pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/8 "2023-04-20T17:55:03Z")
ok. So you mean there is nothing I CAN DO now right? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 20, 2023, 11:51pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/9 "2023-04-20T23:51:24Z")
I let the team know via Slack, no responses so far, I’ll update you accordingly. ---
**Author:** ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)\ **Post date:** [April 24, 2023, 8:20pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/10 "2023-04-24T20:20:11Z")
How are you determining the minutes? ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 25, 2023, 6:43am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/11 "2023-04-25T06:43:10Z")
Hey, I use “date difference” and set start and end date. In the field “unit” you have to write minutes… than it works 😉 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 25, 2023, 7:20am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/12 "2023-04-25T07:20:33Z")
hmm, I wonder if that might be failing for your regional settings. I’ve seen this behaviour before with other date related plugins. Try using a math column instead with the following formula: ```auto Trunc((End - Start) * 1440) ``` That should give you the same result as the Date Difference column, but will be more reliable. ---
**Author:** ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)\ **Post date:** [April 25, 2023, 4:07pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/13 "2023-04-25T16:07:21Z")
Ya I used date difference and didn’t see any issue as well. Thanks for coming back and clarifying. ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [April 30, 2023, 12:38pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/14 "2023-04-30T12:38:51Z")
Do you have an update here? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 30, 2023, 11:52pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/15 "2023-04-30T23:52:14Z")
No updates, in fact Jeremy from the team already responded above, so I don’t expect any updates in Slack. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 1, 2023, 3:32am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/16 "2023-05-01T03:32:47Z")
> [@Andreas\_Ramelsberger](#): > > Do you have an update here? Did you try my suggestion? ---
**Author:** ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)\ **Post date:** [May 1, 2023, 10:59am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/17 "2023-05-01T10:59:16Z")
yes I tried it out. In general it works… but I thought glide will also solve the failure from their side. Best Andi ---
**Author:** ![Brij\_Mohan\_Sharma](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brij_mohan_sharma/32/63672_2.png) [@Brij\_Mohan\_Sharma](https://community.glideapps.com/u/Brij_Mohan_Sharma)\ **Post date:** [November 30, 2023, 8:19am UTC](https://community.glideapps.com/t/google-calendar-integration/60629/18 "2023-11-30T08:19:06Z")
how to turn that on ? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 30, 2023, 12:47pm UTC](https://community.glideapps.com/t/google-calendar-integration/60629/19 "2023-11-30T12:47:07Z")
When you edit a Date Time column, you should see the option to respect time zones there. ![Screenshot_20231130-064515](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/79af2bcc5e7fab12b8e1bf527e42d2a6704a0877.jpeg) ![Screenshot_20231130-064647](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46c704b0bfac4735a9836bb9594fe56f42ffe98b.png)