Convert Time Zones with Power Query

Have you ever gotten date information for different systems and the dates were different from your local time? I don't mean the format like it was mm/yy/dd versus dd/mm/yyyy. I mean that the systems encoded it in different time zones. One table may have information in GMT or UTC date format and another one has it in GMT -8. You are suppose to reconcile these date to see if they match or even do calculations to see if a duration has been met. It might not be so bad to do it in Excel by calculating the difference of 8 hours for GMT and Pacific Time...but what if you also had to deal with daylight savings time? Uggh...it gets complicated...but not so if you have Power Query. See the video to learn how Power Query makes time zone conversion easier.

📝 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!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[joshuaguffey]

Thanks Doug! I regularly have to compare call data from multiple systems and timezones to find matches and discrepancies. I'd been trying to figure out how to tackle it using Power Query but hadn't had much luck. I'll give this a try!

[entertainmentgalaxy]

thanks for sharing time zone fun with PQ

[foovoo]

hi, the time I used is the UK summer time, and I add the the time zone zero to it, and use datetimezone.tolocal this, and I get the local time with -8 or -7 time zone, how could it be ?