Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an excel funtion to calculate Daylight Savings Time?
For the lookup-a-table & present the extracts bit ...
VLOOKUP or the more versatile INDEX/MATCH would spring to mind Try Debra's nice coverage on these functions at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "JRBLS89" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function to calculate interest on savings | Excel Worksheet Functions | |||
Happy Daylight Savings | Excel Discussion (Misc queries) | |||
formula to calculate savings from paying loan off sooner | New Users to Excel | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Template to calculate Compound Interest on Savings | Excel Discussion (Misc queries) |