# Thread: Convert GMT to PST for classes (XP)

I

2. ## 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. ## Re: Convert GMT to PST for classes (XP)

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

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

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

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

8. ## 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>

9. ## 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

10. ## 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.

#### Posting Permissions

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