
Dashboards
Power Query
Advanced Excel Formulas

May 8, 2018

Good morning all,
Is there a way to change the time zone in a time column in power pivot for example from UTC to EST or any other time zone.
Thank you,
Rosa

VIP

Trusted Members

December 7, 2016

Hello,
If you know the time difference between the zones you can easily add or subtract the time difference to your original time.
Example:
Universal Time Coordinated (UTC) is: 18:12:20
Central European Summer Time (CEST) is: 20:12:20
If you want to convert the UTC time to CEST, just add 2 hours. The time is in cell B4.
=B4+TIME(2,0,0)
You can read more about how to work with time converting here.
https://www.myonlinetraininghu.....e-function
Br,
Anders

Answers Post


July 16, 2010

Hi Rosa,
There are various time zone functions in Power Query. The one you need will depend on your data format. You can see them here.
Mynda

Dashboards
Power Query
Advanced Excel Formulas

May 8, 2018

1 Guest(s)
