Path: news.mathworks.com!not-for-mail
From: "Steve " <steveDEL.bachmeierDEL@yahoo.com>
Newsgroups: comp.soft-sys.matlab
Subject: daylight savings adjustment
Date: Wed, 1 Aug 2007 17:52:42 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 3
Message-ID: <f8qh9a$l69$1@fred.mathworks.com>
Reply-To: "Steve " <steveDEL.bachmeierDEL@yahoo.com>
NNTP-Posting-Host: webapp-01-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1185990762 21705 172.30.248.36 (1 Aug 2007 17:52:42 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Wed, 1 Aug 2007 17:52:42 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1034320
Xref: news.mathworks.com comp.soft-sys.matlab:422080



I have several years' worth of hourly data in Excel.  Times are given and they take into account daylight saving.  How can I locate all of the time data that is affected by daylight saving (as of 2007, it starts at 2:00 AM on the second Sunday in March and ends at 2:00 AM on the first Sunday in November) and subtract one hour from the values?

This one has stumped me for a while now.  Any help is appreciated.  Thanks!