Is there an excel funtion to calculate Daylight Savings Time?

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top