rtod2
asked on
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.
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.
ASKER
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.
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()+vl ookup(B2,s heet3!A:B, 2,false)/2 4+vlookup( C2,sheet3! C:D,2,fals e)/24+5/24 ,"HH:mm:ss "))
The same vlookup has been added to the formulas in column D-F
Cheers,
Curt
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()+vl
The same vlookup has been added to the formulas in column D-F
Cheers,
Curt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good stuff. Can you fix the mouse-over text so that it it only shows the message to the user.
ASKER
New question here >> https://www.experts-exchange.com/questions/26899902/Alternating-colors-for-rows.html
Curt