Converting Text to Datetime Format and Then Converting From GMT to Local Time

[jbayko]

Hello Experts -

I'm receiving text in the following format:

DDD MMM DD YYYY HH:MM:SS TZ
Example: "Thu Oct 06 2016 11:53:28 GMT+0000 (UTC)"

Ultimately, what I want to do is convert this to my local date/time, which is Pacific Daylight Time / Pacific Daylight Saving Time (PDT), so that I can create graphs with my local date/time on the X axis. I imagine that I would need to convert this text to some sort of Datetime object in Excel and then convert it from GMT to PDT.

I've been successful in converting the text string to a date/time object using the following formula:
=DATE(MID(A2,12,4),MONTH(1&MID(A2,5,3)),MID(A2,9,2))+TIME(MID(A2,17,2),MID(A2,20,2),MID(A2,23,2))

However, I have no idea how to give this date/time timezone "knowledge" and/or how to convert from UTC to PDT.

Your help would be greatly appreciated!

 

[yky]

=date(mid(a2,12,4),month(1&mid(a2,5,3)),mid(a2,9,2))+time(mid(a2,17,2),mid(a2,20,2),mid(a2,23,2))-7/24