# Timezone Conversion
**URL:** https://community.glideapps.com/t/timezone-conversion/8550
**Category:** Ask for Help
**Created:** [May 6, 2020, 2:37am UTC](https://community.glideapps.com/t/timezone-conversion/8550 "2020-05-06T02:37:07Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@ray\_d](https://community.glideapps.com/u/ray_d)
#### Post date: [May 6, 2020, 2:37am UTC](https://community.glideapps.com/t/timezone-conversion/8550/1 "2020-05-06T02:37:08Z")
I’ve created an events app that accepts events from different timezones. In my form I capture Date Time of the event and require them to choose their time zone. Each time zone has associated with it the + or - UTM in a second field UTM Offset.
I’m wondering if there’s a way to allow a user to choose their own time zone, then dynamically update the event times displayed based on their time zone.
Wondering if anyone has achieved this before?
Any recommendations if this is possible within glide or outside of glide via formulas?
---
### Author:  [@Alex\_G](https://community.glideapps.com/u/Alex_G)
#### Post date: [May 25, 2020, 5:57pm UTC](https://community.glideapps.com/t/timezone-conversion/8550/2 "2020-05-25T17:57:28Z")
+1 I have the exact same issue. I feel like I am so close, just missing this key puzzle piece.
Calling in the cavalary!
@Mark @Jeff_Hager
Each of you have had thoughtful answers to the timezone problem in other threads.
Our app involves users submitting their availability to meet. We want other users to view this availability from their own local time, hence having users select local time zones and passing everything through a standardized UTC date/time is essential.
In our app we will have users select their preferred country time zone and the date/time picker. Then I have a UTC Offset column corresponding to the time zone. The offset is in seconds, and can also be translated to hours using a Math function: SECONDS / 360.
The question is how to apply the offset (in either seconds or hours) to the submitted local date/time and create a translated UTC date/time.
I tried to use the Math function to add/subtract the offset to the local date/time (LOCAL + OFFSET), but it only shows the OFFSET number.
BTW, these were handy CSV data files for grabbing UTC offsets for standard time zones:
> **[bproctor/timezones](https://github.com/bproctor/timezones)**
>
> CSV of timezones with UTC offsets. Contribute to bproctor/timezones development by creating an account on GitHub.
> **[TimeZoneDB](https://timezonedb.com/download)**
>
> Provides world time zone database download and API access.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 25, 2020, 11:04pm UTC](https://community.glideapps.com/t/timezone-conversion/8550/3 "2020-05-25T23:04:52Z")
Unfortunately Glide does not perform any date calculations. It just returns zero, so that’s why your result is only the offset number in the math column. I use dates and date ranges heavily in my app, so for now I have to rely heavily on google sheet formulas to perform any date compares or date math functions. Fortunately for me, I don’t have to deal with different timezones.
You may have to create several columns in your sheet to calculate the offset for each timezone from the entered date/time. Then possibly conditionally show different timezone data based on the user’s preferred timezone. You may be able to create a complex if/then column that will check each each offset to see if it matches the user’s selection and then return the date/time value from the relevant column that matches that offset.
---
### Author:  [@Manuel\_Rodriguez\_do](https://community.glideapps.com/u/Manuel_Rodriguez_do)
#### Post date: [May 26, 2020, 2:21pm UTC](https://community.glideapps.com/t/timezone-conversion/8550/4 "2020-05-26T14:21:35Z")
According to my experience glide does not convert correctly the timezone according to the device settings. Take a look here:
> [@Timezone Incorrectly converted by GLIDEAPP (conversion is doing the opposite of what it is supposed to do)](https://community.glideapps.com/t/timezone-incorrectly-converted-by-glideapp-conversion-is-doing-the-opposite-of-what-it-is-supposed-to-do/8865):
>
> My app’s URL: [https://yfhnb.glideapp.io](https://yfhnb.glideapp.io) I am struggling with timezones in calendar view and seems that there is a bug in the timezone conversion from the google sheets date time to user specific settings. It seems that the conversion is wrongly done in a symmetrical way (i.e. GMT-3 is instead converted to GMT+3 or GMT-1 is instead converted to GMT+1) To demonstrate this I created 3 events in GMT timezone, being my computer and the google sheets settings also in GMT) and gave the name of the …