Convert Time Zone

[ServiceEnvoy]

I am building a database to track ebay auctions and they are all
listed as PDT time. I have a field called "localtime". Is there a
way to set the "localtime" field to look at the "PDTTime" field and
automatically calculate the local time?

 

[Klatuu]

You need to identify the time zone for each location as an offset from GMT or
Zulu time. GMT would be 0 The next time zone to the east is GMT - 1.

Now, there are a couple of places in the world that don't adhere to that
basic concept. Newfoundland, for example is 1/2 hour off the standard time
zone. I think there are one or two more, but I don't know where they are.

I would google for it. I would bet someone already has done this.

 

[ServiceEnvoy]

I'm in CST and need to convert from PDT.

 

[Klatuu]

Assume dtmPST is pacific time:

=DateAdd("h",2,dtmPST)

Will return Central time.