Change Color and Text

are you doing this in GoogleDocs?  or do you want it in Excel - the solution in Excel can determine what time zone you're already in.  Not sure Google Docs can do that.

I want it based on CT.  The GoogleClock function uses a current time zone of the viewer.  I want to force Central Time.

Here's the Excel solution, using source to get the UTC time from: http://excel.tips.net/T002185_Automatically_Converting_to_GMT.html

I converted to get the GMT time, then subtrated 6 hours to get Central Standard Time, then did a simple if statement and conditional format for the coloring.

See attached,

Dave
marketStatus.xls

For Google Docs - here's the link on getting UTC for GMT and you can do math from there:

http://knol.google.com/k/google-docs-guide-2/google-docs-help-import-functions-speed/2vcnhxffa8r42/19#

Dave

Are you there?  I got it to work.

I created an import on the time, then converted the resultant string to a time that I added 18 hours to (or could subtract 6 from) to get the CST.  The rest is straightforward, right?

Dave

Here you go.  Its in Excel, but you can move it up to Google Docs:

After you get it there, put this command in cell B9 - its supposed to refresh hourly. and the link above will help if you want more frequent refreshes.

=importHTML("http://timeanddate.com/worldclock","table",2)

Let me know if this helps or if more assistance is required.

Enjoy!

Dave
marketStatus.xls

Hmmm..    Discussing B3 here >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdG8yTzVWSnJPbWpFdmJJSWFBUVhERXc&hl=en&authkey=CNPC_ZkP#gid=0

I opened it for editing but don't wish to mess with any of the other values until we get this one right.  Assistance is greatly appreciated.

ok - I have a few minutes - you want to chat there?

Dave

Incredible!