Results 1 to 5 of 5

Thread: Time Conversion

  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Time Conversion

    How would one take this:

    2011-06-09T17:56:25.788Z

    and convert it to PDT using a formula


    thanks
    John
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    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. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    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. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,203
    Thanks
    49
    Thanked 989 Times in 919 Posts
    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. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    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.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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