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

[image] TIme Zones - Current Time In Good Morning, Has anyone added or know if it can be added a time zone feature that can show current time?

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 (pa…

how do you adds/subtracts the timezone choice?

@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?

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.

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

[image] 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.

Either way, How to convert from one time zone to another?

Would this work for you? [image] TIme Zones - Current Time In 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…

Help needed - display a time based on users time zone

Ask for Help

Wiz.Wazeer June 23, 2020, 9:19pm 2

Topic		Replies	Views
TIme Zones - Current Time In Ask for Help	7	1173	November 1, 2020
Show a calendar according to the user timezone Ask for Help	6	1048	January 21, 2021
Display date/time in local user's timezone Ask for Help	7	2018	June 25, 2020
Automatic Time Zone Conversion without a lookup table (Solved) Ask for Help	0	719	January 12, 2021
Is Date Time Stamp - Local Time only? Ask for Help	9	882	May 26, 2020

Help needed - display a time based on users time zone

Related topics