Time Conversion

[t8ntlikly]

How would one take this:

2011-06-09T17:56:25.788Z

and convert it to PDT using a formula


thanks
John

[tfspry]

Is the time of 17:56:25 a PDT time or is it a time from some other Time Zone that you want converted to PDT?

[tfspry]

Assume you just want to extract a time value from your string.
If your string is in Cell A1, try this....
=VALUE(MID(A$1,12,8))

Here are some possible formats.....
5:56:25 PM
5:56 PM
17:56:25
17:56

[Paul T]

I think the Z suffix indicates UTC. Pacific Daylight Time is UTC - 7.
In Excel date/time format 1 = 1 day, so 7 hours = (1/24)x7.
With your data in A1 enter this in A2. =A1-(1/24)*7

cheers, Paul

[RetiredGeek]

Paul,

Thanks for the explaination that 1 = day in Excel. I often wondered how the calculations for date/time worked. I had thought 1 = hour. And how long have I been using Excel...far too long not to know that!!!! Luckily I never did much in the way of time calculations.