# \[Conference\]Display Event Time by Timezone **URL:** \ **Category:** Ask for Help\ **Created:** [October 5, 2021, 9:20pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701 "2021-10-05T21:20:47Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Adeste\_Sipin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adeste_sipin/32/32688_2.png) [@Adeste\_Sipin](https://community.glideapps.com/u/Adeste_Sipin)\ **Post date:** [October 5, 2021, 9:20pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/1 "2021-10-05T21:20:47Z")
We’re running a virtual conference. Our schedule (and spreadsheet settings) is set to Eastern Standard Time. People are going to be logging in from all over the United States. I would like for the scheduled events to adjust to the User’s time. That way, someone in the pacific time zone will know that the welcome starts at 9am while someone in the east coast will see the welcome starting at 12pm to account for the timezone difference. As of now, what is displayed on the schedule is the date/time in eastern time as it is entered that way into the google sheet. ![glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/2155a7254ce7407f4fe050f04c9ff92bb5b54a44.png) ---
**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:** [October 5, 2021, 9:28pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/2 "2021-10-05T21:28:03Z")
This might help. You can create a template column with the date/time and “GMT-4” or or possibly EST or ET appended to the end. Then use that template column as your calendar date and I believe it should adjust accordingly for each user. Or you can adjust your time to GMT time and then calculate the user offset automatically and adjust the time with some date math. This is what I do in this example. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524): > > This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to… ---
**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:** [October 5, 2021, 9:35pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/3 "2021-10-05T21:35:53Z")
Sorry, I should have said EDT instead of EST since we are still in daylight savings, but maybe ET will cover both. I’m not sure though. ---
**Author:** ![Adeste\_Sipin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adeste_sipin/32/32688_2.png) [@Adeste\_Sipin](https://community.glideapps.com/u/Adeste_Sipin)\ **Post date:** [October 5, 2021, 10:01pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/4 "2021-10-05T22:01:24Z")
Thank you so much @Jeff_Hager I’ll give it a try! ---
**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:** [October 5, 2021, 11:33pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/5 "2021-10-05T23:33:18Z")
Adding to Jeff’s answer, if you ever want to have those being able to be submitted by people from any timezones (not just GMT-4), then you can calculate their offset in the user profiles sheet and submit that info alongside the new event when someone adds to that Sheet using a form in the app. ---
**Author:** ![Adeste\_Sipin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adeste_sipin/32/32688_2.png) [@Adeste\_Sipin](https://community.glideapps.com/u/Adeste_Sipin)\ **Post date:** [October 6, 2021, 9:36pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/6 "2021-10-06T21:36:08Z")
Thanks again @Jeff_Hager I was able to 1. Go into my google sheet 2. Added two columns 3. one column for EDT 4. The 2nd column was concate formula for the original date/time and EDT (with a space before EDT in the EDT column 5. Then I copied and pasted the concatenated value (paste special copy value only) back into the date/time column 6. Deleted the two extra columns 7. Refreshed/synced the app with the spread sheet 8. And now, what is entered as 12:00 EDT shows up as 9:00 am on my local device! ![glide2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d002545590e2ea9129858bc8a31c86fdd0d7fa22.png) I need to ask my colleague in the east coast to verify that hers still says 12:00pm. Hoping this solved the problem!!! _UPDATE_ Her app showed the correct time! WOOHOO! Thanks again! BTW I entered and recreated your GMT app and while it was fun and I learned a lot, your initial suggestion of just adding EDT did the trick! Thanks again! Adeste ---
**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:** [October 7, 2021, 1:37am UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/7 "2021-10-07T01:37:44Z")
Glad you got it to work! Just some advice, which I’m sure you realized in my app, is that you probably could have avoided any temporary columns in the google sheet itself. If you know your times are always going to be based on EDT, I think you could have simply created a template column in the glide data editor to join the date column and EDT. The template column would be your your date source for the calendar in the app. The glide calendar is incredibly flexible at interpreting text based dates and times in a variety of formats. Maybe you have reasons for doing it the way you did. 😉 Nothing wrong with how you did it, but just something to keep in mind for the future. Here’s another thread for some inspiration. > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/8 "2024-01-17T16:50:06Z")