I have a table with a seperate record for each day of the year. On this record I have 4 times (ie. 4:00AM 6:20AM 3:35PM 8:30PM). I run calculations on this table based upon adjustments to each time (ie 30 minutes, 45 minutes....)The program also has to adjust for changes from one day to the next and vice versa if the adjustment is a negative. All works fine except for Daylight Savings Time. Is there a way to tell the program or calculation to adjust for DST or will I have to hard code the actual dates for DST in the calculations.
BTW, the base starting table before adjustments get calculated by some other means and does not account for DST.(I already thought of that)
TIA,
Jamie