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.myonlinetraininghub.com/excel-time-function

Br,
Anders

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

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

Hi Rosa,

Please provide a sample Excel file so we can see what errors you're getting and the data structure you're working with.

Mynda

Good morning,

Here is the sample file the times reflected in the file are in GMT and the correct time format that i need is EST.

Thank you,

Rosa