# Help needed - display a time based on users time zone **URL:** \ **Category:** Ask for Help\ **Created:** [June 23, 2020, 8:21pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341 "2020-06-23T20:21:28Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [June 23, 2020, 8:21pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/1 "2020-06-23T20:21:28Z")
Hello, Does anyone know how to display a time based on user’s timezone? I saw i can use users location but I feel it wont be easy going this road(how to get time zone based on that location) Is there an easy way to do that? @Mark @Jeff_Hager ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [June 23, 2020, 9:19pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/2 "2020-06-23T21:19:33Z")
> [@TIme Zones - Current Time In](https://community.glideapps.com/t/time-zones-current-time-in/10856): > > Good Morning, Has anyone added or know if it can be added a time zone feature that can show current time? ---
**Author:** ![Cmstewart42](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cmstewart42/32/7319_2.png) [@Cmstewart42](https://community.glideapps.com/u/Cmstewart42)\ **Post date:** [June 25, 2020, 6:51am UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/3 "2020-06-25T06:51:35Z")
Hello @Leon_Kol , You could allow each user in their profile to choose their timezone manually from a list. Then you just have to offset their time from your sheets local time (your time) and then there time will be available. Please note that unless you have your sheet updating automatically (paid plans) your users will have to manually trigger a refresh to show the current time (any update to the sheet from glide will do so). I have my time shown in an action text component with the title “Current Time (tap to refresh)” with a configured action to simply increment a “refresh” cell on my sheet. This causes the app to pull the new time data. I just went to wikipedia and grabbed the timezone table, then in each of the users rows I added a time and timezone field. The time takes the sheet time (from somewhere in my sheet) and adds/subtracts the timezone choice (adjusting for my timezone not being UTC). Please let me know if you have any questions, I have put the above together and it is working. Good luck! ---
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [July 4, 2020, 10:19am UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/4 "2020-07-04T10:19:54Z")
how do you adds/subtracts the timezone choice? ---
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [July 4, 2020, 10:21am UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/5 "2020-07-04T10:21:35Z")
@Mark @Jeff_Hager Would you have any idea how to do that? Sheets Script can help? If i run `new Date()` It will get me the sheets timezone 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:** [July 4, 2020, 10:50am UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/6 "2020-07-04T10:50:21Z")
You have the timezone information upon each user’s registration. Extract the timezone VALUE using a RIGHT formula (if I recall right about the timezone format, it’s UTC plus a number?). Then you can do calculation with that formula, but it would all be done in the Sheets. ---
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [July 4, 2020, 11:55am UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/7 "2020-07-04T11:55:22Z")
How to you get a timezone upon registration? I have only a position and i extracted timezone > RIGHT formula useful to return a substring from the end of a string so I don’t see how it helps ---
**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:** [July 4, 2020, 12:00pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/8 "2020-07-04T12:00:49Z")
> [@Cmstewart42](#): > > You could allow each user in their profile to choose their timezone manually from a list. Here, it would be much easier if you ask them to fill in a choice upon registration, rather than trying to get it from the location. ---
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [July 4, 2020, 12:03pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/9 "2020-07-04T12:03:52Z")
Either way, How to convert from one time zone to another? ---
**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:** [July 4, 2020, 12:40pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/10 "2020-07-04T12:40:24Z")
Would this work for you? > [@TIme Zones - Current Time In](https://community.glideapps.com/t/time-zones-current-time-in/10856/7): > > Yeah I would envision you to have something like. User name User country A lookup column to show the difference between their country timezone and your now() Their now() time - calculate via a formula to add/subtract time ---
**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\ **Post date:** [July 4, 2020, 12:44pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/11 "2020-07-04T12:44:43Z")
Formula in glide or Sheets? ---
**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:** [July 4, 2020, 1:21pm UTC](https://community.glideapps.com/t/help-needed-display-a-time-based-on-users-time-zone/11341/12 "2020-07-04T13:21:09Z")
It should be the done in the Sheets because Glide hasn’t supported calculation with time yet.