Log In
Register
Home
Dashboards
Power Query
Advanced Excel Formulas
May 8, 2018
Offline
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
See Answer
VIP
Trusted Members
December 7, 2016
Offline
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
Offline
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
Offline
Good afternoon,
Thank you all for your help. Mynda i looked at the different functions and try to play with them but i am getting errors. i am not sure how to use these functions in power query.
Rosa
1 Guest(s)
