rtod2
asked on
Time Zone descriptor needed in Col B
Column B needs time zone descriptor also.
Example UTC -5:00 Central Time, US.
Also the plus(+) or minus(-) sign in front of the zone should be stated explicitly.
my sheet >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en
potential examples >> http://www.michaelapproved.com/articles/timezone-dropdown-select-list/
Assistance is greatly appreciated.
Example UTC -5:00 Central Time, US.
Also the plus(+) or minus(-) sign in front of the zone should be stated explicitly.
my sheet >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en
potential examples >> http://www.michaelapproved.com/articles/timezone-dropdown-select-list/
Assistance is greatly appreciated.
ASKER
You're amazing!
ASKER
Thanks, glad to help. Next question seems to be well in the hands of user 5111.
Curt
Curt
I need to understand this.
Are we updating the info at google?
Do we save it back there?
What happens if more than one users save it with different updates?
In any case I think we should be posting the results in this forum because the sheets may be deleted from google and this question looses its functionality.
Saqib
Are we updating the info at google?
Do we save it back there?
What happens if more than one users save it with different updates?
In any case I think we should be posting the results in this forum because the sheets may be deleted from google and this question looses its functionality.
Saqib
You are right Saqib. The only reason I haven't posted anything back was that question was accepted after I updated the google spreadsheet and before I got back to the question. The solution also becomes somewhat irrelevant in this case since it will only work on the google spreadsheet. Anyway using the now updated version:
Tables changed in sheet3 to add a description i A and Time Zones in B
enter in C2
=if(A2="","",mid(text(now( )+vlookup( B2,sheet3! A:B,2,fals e)/24+5/24 ,"'Weekday 'EEE"),8,10))
and copy down
enter in E2
=if(A2="","",text(now()+vl ookup(B2,s heet3!A:B, 2,false)/2 4+5/24,"hh :mm:ss a"))
and copy down
enter in F2
=if(A2="","",text(now()+vl ookup(B2,s heet3!A:B, 2,false)/2 4+5/24,"HH :mm:ss"))
and copy down
Cheers,
Curt
Tables changed in sheet3 to add a description i A and Time Zones in B
enter in C2
=if(A2="","",mid(text(now(
and copy down
enter in E2
=if(A2="","",text(now()+vl
and copy down
enter in F2
=if(A2="","",text(now()+vl
and copy down
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.
Curt