# TIme Zones - Current Time In

**URL:** <https://community.glideapps.com/t/time-zones-current-time-in/10856>\
**Category:** Ask for Help\
**Created:** [June 14, 2020, 2:05pm UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856 "2020-06-14T14:05:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kara](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kara/32/2193_2.png) [@Kara](https://community.glideapps.com/u/Kara)\
**Post date:** [June 14, 2020, 2:05pm UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/1 "2020-06-14T14:05:23Z")

</div>

Good Morning,

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

---

<div class="post-metadata">

**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 14, 2020, 11:34pm UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/2 "2020-06-14T23:34:21Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Kara](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kara/32/2193_2.png) [@Kara](https://community.glideapps.com/u/Kara)\
**Post date:** [June 15, 2020, 12:25am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/3 "2020-06-15T00:25:28Z")

</div>

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

---

<div class="post-metadata">

**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:** [June 15, 2020, 12:30am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/4 "2020-06-15T00:30:49Z")

</div>

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.

---

<div class="post-metadata">

**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 15, 2020, 12:32am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/5 "2020-06-15T00:32:21Z")

</div>

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

> [@Timezones](https://community.glideapps.com/t/timezones/482/2):
>
> 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://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales](https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales)
> 
> I believe login timestamps will be in your spreadsheet’s timezone and formatting… but I might have to test that out to see. Let me know if you find otherwise.

---

<div class="post-metadata">

**Author:** ![Kara](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kara/32/2193_2.png) [@Kara](https://community.glideapps.com/u/Kara)\
**Post date:** [June 15, 2020, 12:44am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/6 "2020-06-15T00:44:01Z")

</div>

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

---

<div class="post-metadata">

**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:** [June 15, 2020, 12:45am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/7 "2020-06-15T00:45:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![PanaYoung](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/panayoung/32/25830_2.png) [@PanaYoung](https://community.glideapps.com/u/PanaYoung)\
**Post date:** [November 1, 2020, 5:52am UTC](https://community.glideapps.com/t/time-zones-current-time-in/10856/8 "2020-11-01T05:52:05Z")

</div>

You can also do it with a math column.

 ![IMG_20201101_005007](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d582210cf3c1b6c4f22cb0e6c89b30e5dbee949b.png)
