Скачать с ютуб Changing Time Zones in Power Query в хорошем качестве

Changing Time Zones in Power Query

When you get date and time values from another systems, sometimes it is in a time zone that is different from yours. For example you might get a field that has a date/time/time zone in UTC or GMT format, but you need to do analysis in Western time. How do you convert the time zone? You could actually do the calculations and offset it by adding or subtracting hours to the UTC value. Switching time zones gets more complicated if you have to deal with daylight saving time. You'd have to find out which zone hour had daylight saving applied and which did not. How you handled the time zones begins by setting or configuring an initial time zone in Power Query for the date/time value. 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr... 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel ~-~~-~~~-~~-~ Please watch: "Convert Table in a PDF File to Excel"    • Convert Table in a PDF File to Excel   ~-~~-~~~-~~-~