Thread: How do I set up an Excel workbook to convert GMT to EST?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How do I set up an Excel workbook to convert GMT to EST?
On Wed, 13 Feb 2008 10:59:05 -0800, 49 forever <49
wrote:

I'm trying to use Excel to make a converter between GMT and EST/EST DST.


Something like:

=A1-5/24+IF(AND(A1=DATE(YEAR(A1),3,15)-WEEKDAY(DATE(YEAR(A1),3,14))
+7/24,A1<DATE(YEAR(A1),11,8)-WEEKDAY(DATE(YEAR(A1),11,7))+7/24),1/24,0)

should convert the date/time in A1, in GMT to EST/EDT in accord with the
current rules (2nd Sunday in March 2AM / 1st Sunday in November 2 AM)
--ron
Reply With QuoteReply With Quote