Change time offset format?

I want to change the offset in column D of the Sheet1 tab to the format shown in column G of the TZ tab.

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

It will be less confusing to read and easier to enter that way.
rtod2Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
OK, I edited it, now you can only select 1 or 0 from the dropdown in column D of sheet1. Is that it, if not then can you explain, thanks

regards, barry
0
 
barry houdiniCommented:
Hello rtod2,

If I understand correctly then Column D in sheet 1 is a dropdown list which allows you to enter one of two values from Sheet3!C2:C3....so try changing Sheet3!C2 to 1 and Sheet3!C3 to 0 and you'll then get that choice in column D.....

regards, barry
0
 
rtod2Author Commented:
Not quite.  Can you show me.  I have just made it editable.
0
 
rtod2Author Commented:
I was looking to eliminate the zeros in favor of the manually input values + or - whatever you wanted.  1.5 would be one and a half hours and -1.5 would be minus 1.5 hours.  1 would be plus 1 hour and -1 would be minus one hour.
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.