Changing Time Zones in Power Query

[@wayneedmondson1065]

Hi Doug.. thanks for the Time Zone madness in Power Query. Good stuff! Thumbs up!!

[@DougHExcel]

Any time!

[@johnfredy17]

Hi Sir! I just want to let you know that it was quite helpful. Therefore, I love you!

[@DougHExcel]

Wow, thanks!!!

[@issapamelagonzalez6045]

Great video! Is there way to change the time zone of my existing column instead of adding new ones? My problem is that the share point storage the data in UTC even is everything else is on EST, I’m trying to have everything matching

[@foovoo3374]

hi, if I have UK summer time BST, and I want to know the UTC time for it, because UK is time zone zero, how could I know the utc time which is BST minus one.

[@raadal-husban654]

Great Video, though it doesn't handle Daylightsaving adjustment twice a year without manual changes

You saved me!!!! Thank you so much.... +1 subscriber nowwwww

[@DougHExcel]

Thanks for the sub!

[@TruePhazon]

How do you do it without adding a column?

[@excelisfun]

100 thumbs ups for the perfect-o Thumb Nail : )

[@DougHExcel]

Thanks Mike!!!

[@vivekpetrohead]

Hi Doug...thanks for the tip. I have a unique situation where the time stamps from the salesforce data is in UTC and i have a custom column to display the same in CST US. However my local time zone is India (IST)...how can i accommodate DST time adjustments to reflect in the CST time column automatically

[@DougHExcel]

maybe this one ruclips.net/video/o-IajstRL9g/видео.html

[@papachoudhary5482]

Thanks! Sir

[@DougHExcel]

You're Welcome!