Populate D based on value in C

I need to populate or un-populate the times in all the rows of column D based on a 'manual input' of + or - values in column C.  The values entered should also be explicit (i.e. +10, -11) instead of a variation (i.e. 10:00 or -11:00), and produce a 12hr clock format using AM or PM.  Assistance is greatly appreciated.  https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en&authkey=COOO6JsO#gid=0
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I added the formula =now()+C3/24 and set the format of the column to h:mm AM/PM. Is it supposed to show the clock based on Now() referencing UTC or central time?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rtod2Author Commented:
That only got one row but at least it does populate with something.  It should do it for all the rows IF there is a UTC +/- offset value in C.  The time populating is incorrect though, even for that one row and should be based off the UTC time offset entered.
rtod2Author Commented:
Almost home.  Thanks for the recent change.  It still needs to say the + or - value explicitly (ex.  +2 if 2 is entered).  That will make a difference here moving forward.
rtod2Author Commented:
partially answered
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.