Adjust for Daylight Savings Time

Sheet >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en  

I need to allow people to select between daylight savings time ON (+1) or OFF (-1) which should adjust the time up/down by one hour on that setting.

If possible, I'd like also to rename the existing selection mouse-overs to say simply "Select A Time Zone" and nothing else.

Assistance is greatly appreciated.
rtod2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Curt LindstromConnect With a Mentor Commented:
Ted,

I worked that one out :-) I'm adding 1 when ON and 0 when OFF.

Curt
0
 
Curt LindstromCommented:
Ok, I'm working on this right now. Will post the solution here in a few minutes

Curt
0
 
rtod2Author Commented:
Sorry Curt.  Off should remain unchanged and On should be (+1).  This would make a -6 default setting for central time for instance move up to -5.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Curt LindstromCommented:
I believe I got this working now.
Formulas have changed to include a lookup from a new small table on sheet3 with ON (+ 1) and OFF (0) adding 1 or 0 to the times.
Formula as added in column G and copied down to the end of current page
=if(A2="","",text(now()+vlookup(B2,sheet3!A:B,2,false)/24+vlookup(C2,sheet3!C:D,2,false)/24+5/24,"HH:mm:ss"))
The same vlookup has been added to the formulas in column D-F

Cheers,
Curt
0
 
rtod2Author Commented:
Good stuff.  Can you fix the mouse-over text so that it it only shows the message to the user.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.