How To Convert Time Zones With Notion

Aug 18, 2022

If you use a tool like NotonCommerce to get product orders from your customers around the 🌏 or part of an international team, You may get the times in UTC format.

But to get a better understanding of time, we sometiems need to convert the time to our local timezone. Lucily we can easliy achive this with Notion formulas! 😌

(If you don’t have the basics of Notion formulas, watching this 👇🏼 video first will be very helpful.)

Convert from UTC

· First visit timeanddate get the timezone offset of your location. For example, If you live in Tokyo, Japan your timezone is GMT +9.00.

· Create a sperate formula column to store you local time.

· Use 👉 dateAdd(prop(“OG Time”), X, “hours”) formula to convert the UTC time to your timezone. (Replace X with your timezone.)

Convert One Timezone to Another

(Be prepared to do some basic math 😜)

If you source time is not in UTC, then only extra thing you need to do is find the hour difference between the source and your own timezone.

Let’s see and exmaple, Here my source is from New York, USA and I need to convert it to Tokyo, Japan

· The Timezone of New York is GMT -4.00 and Tokyo is GMT +9.00. So my hour difference is +13.00.

· Now your formula will me dateAdd(prop(“OG Time”), 13, “hours”).