1. ## Time Conversion

How would one take this:

2011-06-09T17:56:25.788Z

and convert it to PDT using a formula

thanks
John

2. 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?

3. 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

4. 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

5. ## The Following User Says Thank You to Paul T For This Useful Post:

RetiredGeek (2011-06-10)

6. 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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•