EST to GMT

Y

YachtFund

Active member

Messages

150

Likes

4

• Feb 15, 2006

• #1

I have some data that I need to turn from EST to GMT since 1997. Anyone got a quick Excel formula???

Or a good idea.

 

J

JonnyT

Senior member

Messages

2,560

Likes

22

• Feb 15, 2006

• #2

Add 5 hours to get GMT in general. However the clocks can change 1 week different to ours.

JonnyT

 

Y

YachtFund

Active member

Messages

150

Likes

4

• Feb 15, 2006

• #3

JonnyT said:

Add 5 hours to get GMT in general. However the clocks can change 1 week different to ours.

JonnyT

Click to expand...

Good to see you back JT.

The dates are different each year though for both EST and GMT so it would be a fiddle and I just hoped someone had done it before.

 

blackcab

Established member

Messages

523

Likes

51

• Feb 15, 2006

• #4

YF - you should be able to work out manually when the clocks changed each year with this page: http://webexhibits.org/daylightsaving/g.html

 

Directional

Experienced member

Messages

1,992

Likes

251

• Feb 15, 2006

• #5

Remember that GMT doesnt change by an hour, GMT is the same all the year round - it is just that everyone revents to BST during the summer.

 

T

TheBramble

Legendary member

Messages

8,394

Likes

1,170

• Feb 15, 2006

• #6

YachtFund said:

Or a good idea.

Click to expand...

How about just using it with the EST data?

 

Y

YachtFund

Active member

Messages

150

Likes

4

• Feb 15, 2006

• #7

Its BST I need. Its for a couple of strategies that over the last year work well during London hours so want to go further back.

Thanks all for your help.