Forum Discussion
Coryanthony
3 years agoHelper III
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...
Coryanthony
3 years agoHelper III
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
3 years agoSuper User
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.