Good Morning, Has anyone added or know if it can be added a time zone feature that can show current time?

Welcome to the community Kara! You just want to show current time on home page? If answer is yes…use =Now() If you want to show current time on every tab…just copy & paste this function to a new column of every single tab.

That will work. Thanks could similar formula populate current time other time zones. We have people in France, Dominican Republic Australia Nairobi Kenya.

That would likely require you to have a sheet to lookup the difference between your current time (the time of the owner’s spreadsheet) and the users. Let’s say you’re GMT+0, I’m GMT+7, then add 7 hours to my “now” time for display.

This all depends on google sheet location. Please read this very helpful article for further assistance. [image] Timezones The app will display date & time formats based on the device location: But if you’re talking about how you see it as you are building, then that’s slightly different: https…

Awesome. That makes sense. Thanks so much. This is exactly what I was looking for.

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

You can also do it with a math column. [IMG_20201101_005007]

TIme Zones - Current Time In

Ask for Help

Wiz.Wazeer June 15, 2020, 12:32am 5

This all depends on google sheet location. Please read this very helpful article for further assistance.

Topic		Replies	Views
Help needed - display a time based on users time zone Ask for Help	11	955	July 4, 2020
How to show the current time of a specifc country? Ask for Help	8	58	September 12, 2024
Work around for timezones Ask for Help	0	472	February 9, 2021
Is there a quick, simple way to add the current local time using an existing component? Ask for Help	1	219	August 20, 2020
Display date/time in local user's timezone Ask for Help	7	2018	June 25, 2020

TIme Zones - Current Time In

Related topics