Forum Discussion

Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper III
3 years ago

Time zone conversion (please help)

Hello, I am looking to convert Central Time zone to Jamaica (GMT-5) time zone.  Jamaica time does not observe day light savings. During winter, it is Eastern Time zone, during summer it is Central t...
Need Help
Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper III
3 years ago

Bmejia 

will this account for day light savings? Data is currently in Central time zone, while Jamaica is 1+ hr ahead during winter and same time during summer.

Thank you for the response.

Bmejia's avatar
Bmejia
Icon for Super User rankSuper User
3 years ago

I don't believe it will, cause you adding the hour or time manually . The only way that it would probably work is if you had a date and time, you could use this, then extract the time.

 

0 is the time zone you want to changed to.
=DateTime.AddZone([MyDateColumn],0)

  • Coryanthony's avatar
    Coryanthony
    Icon for Helper III rankHelper III
    3 years ago

    Thank you Bmejia 

    i can go back a few steps. So if i have date and time together, i can create a new column using =DateTime.AddZone([MyDateColumn],0) ?

     

     

    • Bmejia's avatar
      Bmejia
      Icon for Super User rankSuper User
      3 years ago

      Yes, so create a new custom column in power query enter the code below, change the value zero to whatever time zone you wanted to be. Then extract the time.