Hello,

I am a new user having just acquired excel 2007 and would appreciate any
help. I have a column of dates
along with time in CST. I live on the west coast and
would like to have excel convert the time part of each
entry to PST, or maybe jump to EST. How do I do
this. The columns are in this format:
2/28/07 9:20

3/4/07 9:20

3/8/07 9:20
Going down the columns, the dates change but the time is constant with
the example showing 9:20 am. It would be nice to have a selector button with
the choice of 0 for CST
-1 for MST
-2 for PST
-3 for XST etc.
What formula goes where? and where on the sheet are the updated times.
I hope to read up on this as I can. Thanks to all in advance.