Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Convert GMT to PST for classes (XP)

    I
    Richard Spring

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert GMT to PST for classes (XP)

    With a date+time in A1, the formula

    =A1-8/24

    will subtract 8 hours from the time. Keep in mind that GMT doesn't have daylight saving time in the summer (UK time does, GMT doesn't), so when you switch to daylight saving time, you're 7 hours behind GMT.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Convert GMT to PST for classes (XP)

    In addition to Hans's answer try:

    =IF(AND(A1>25/3/2007, A1<28/10/2007),A1-7/24,A1-8/24)
    Jerry

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert GMT to PST for classes (XP)

    Jerry, that's for the European daylight saving time period. For most of the United States, it'll be from March 11 until November 4 this year.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Convert GMT to PST for classes (XP)

    Thanks Hans and Jerry:
    Both formulas work great. Jerry's inclusion of the upcoming daylight savings time is helpful.

    Now, off to class.
    Richard Spring

  6. #6
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Convert GMT to PST for classes (XP)

    Hans, you are right.
    I forgot they messed with the start and stop dates this year.
    More daylight to play in the sun and swimming pool.
    Richard Spring

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Convert GMT to PST for classes (XP)

    Thanks Richard,

    Sorry about the dates, I was assuming that you were European <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I went to the site you show above and it does look very good, I will pass this on to some of my non-IT clients who need a brush up on the subjects.

    Good luck on your course, make sure you come back and share your knowledge <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert GMT to PST for classes (XP)

    <hr>
    I was assuming that you were European
    <hr>

    Then PST must be Polish Standard Time, and they must have moved Poland 9 time zones to the west. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

  9. #9
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Convert GMT to PST for classes (XP)

    Darn, you got me there <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    <img src=/S/note.gif border=0 alt=note width=20 height=20>To myself.....read the question carefully
    Jerry

  10. #10
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Las Vegas, Nevada, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Convert GMT to PST for classes (XP)

    I do not think this is Poland, but we are having over 250,000 visitors this weekend in Las Vegas for the basketball thing! <img src=/S/basket.gif border=0 alt=basket width=58 height=52>

    I will keep you advised regarding the classes.

    From the middle of the desert, where it gets over 110 degrees F. in the summer.
    Richard Spring

Posting Permissions

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