View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JRBLS89 JRBLS89 is offline
external usenet poster
 
Posts: 1
Default Is there an excel funtion to calculate Daylight Savings Time?

I would like to create a spreadsheet that when you enter a time you are able
to present EST, CST, MST, Arizona, PST, AKST, HST and possible the changes
for DST. The way I tell my team to look up instead of guessing is a site:
http://www.timetemperature.com/tzus/time_zone.shtml where they can pick the
state and show the current time.

I would like the first Column (A) to be date and then across the rows show
the adjusted time from EST (B) to HST (G or H if AZ is calculated).

Before I get to deep and spen hours making a spreadsheet of my own with
pivot tables, I was wondering if someone did this already?