Changing Time To Different Timezones

[Sid Saul]

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.

 

[Guest]

Microsoft TIME format is a count of days from Jan 1 1900. Hours minutes
seconds are fractional part of thsi format. It looks like your times are in
microsoft time format. to add or subtract two hours your will need to use
the =time(-2,0,0) function.

If your cell with the time is in C5 the to subtract two hours use

=C5 + TIME(-2,0,0) which is -2 hours 0 minutes and 0 seconds.