Is there an excel funtion to calculate Daylight Savings Time?

  • Thread starter Thread starter JRBLS89
  • Start date Start date
J

JRBLS89

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?
 
Back
Top