Changing Time To Different Timezones

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.


0
n541 (1)
3/10/2007 2:16:21 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
683 Views

Similar Articles

[PageSpeed] 29

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.
"Sid Saul" wrote:

> 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.
> 
> 
> 
0
Joel (168)
3/10/2007 8:46:06 AM
Reply:

Similar Artilces:

Auto change formula in cells when source is changed
Good day experts; If specific cells have the same formula for example: C1 = Product( A1;B1) C16 = Product(A16;B16) C17= Product(A17;B17) And so on ... What formula should i write in C16, C17, ... so that: when the formula in the source cell, C1, is changed the formulas in C16, C17, ... would automatically change accordingly. I tried "=C1" it does not work Thanks in advance Carlo carlo wrote: > Good day experts; > > If specific cells have the same formula for example: > C1 = Product( A1;B1) > C16 = Product(A16;B16) > C17= Product(A17;B17) > And so on ... ...

Outlook Express Visual C++ Runtime Library Run-Time Error
I have a friend who's using Outlook Express 6 and is getting an "abnormal program termination" error whenever he attempts to attach a graphic file within Outlook Express. He reports that it works fine when using the Explorer shell to call OE. My friend has WinXP Home. Any advice? Jay ...

Convert time stored as decimalised number to time format
Hello How can I convert 3.5 hours to 3:30:00? -- Emma Emma A1/24 and formate as time Mike Rogers "Emma" wrote: > Hello > How can I convert 3.5 hours to 3:30:00? > -- > Emma ...

Changing a text field to a date field
Hi I know this is a problem for lots of people but I still cant find an answer. I have imported a text file into excel with a number field that displays credit card expiry dates as a 4 digit number. example 0408 so month + year. I have converted the number field to a text field so it doesnt drop off the first zero and now I need to convert it to a date field. Any nice easy simple ideas. Any help would be much appreaciated. Or direction to a question the same. Perhaps =DATE(100+RIGHT(A1,2),LEFT(A1,2),1) format as date -- daddylonglegs --------------------------------------------...

Count column difference
Hi Using MSExcel 97. I have two columns of data e.g. A1: A4, containing values 5,10, 3, 6 B1:B4, containing values 3, 8, 7, 4 I wish to perform a count (e.g. in C5) of the number of rows where the value in column A exceeds the respective value in column B (in this case count = 3, as A1>B1, A2>B2, and A4>B4). Just cannot get my formula right. Tried using an array (but difficult when comparing the difference between two columns), and COUNT. Thanks in advance for any suggestions. Wizzy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.co...

Problem changing wallpaper on Vista
I am trying to change the wallpaper on Vista. I have a sub that works on XP with .jpg and .bmp images... Private Sub SetActiveDesktopWallpaper(ByVal sFileName As String, ByVal lStyle As Long, ByVal fForce As Boolean) Dim ad As ActiveDesktop Dim co As COMPONENTSOPT Dim wpo As WALLPAPEROPT Set ad = New ActiveDesktop 'check if AD is enabled co.dwSize = Len(co) ad.GetDesktopItemOptions co, 0& With wpo .dwSize = Len(wpo) .dwStyle = lStyle End With With ad ' set wallpaper style... .SetWallpaperOpt...

Forms in two differant views
Is there a way to use the same sub form showing two differant views within the same Main Form. For example: Can I show on one tab a datasheet view and on the other a regular form view. -- Rose Hi Rose, Create a button on your form and under the "OnClick" event put 'Me.DefaultView = Datasheet Alternatively you could use a checkbox If me.checkbox1 = 0 then Me.DefaultView = 2 ' Datasheet Else Me.DefaultView = 0 'Single Form End if me.repaint This should flick the form between datasheet and form views. HTH, Nick. "Rose" wrote: > Is there a way to use t...

Date and time onto a form
Hi, I am designing a form that my client would like the date and time automatically recorded in a field and stored so that when they refer back it shows when the record was done. The 'NOW' function only shows the current date & time and keeps updating. Is there a way of putting the 'NOW' value into a field, then locking it so it doesn't change when the record is reopened. Hope that makes sense! Kazlou The form stores data in a table. You need to add a date/time field to your table to record the date and time a record was last updated. 1. Open the table in desig...

Statment of changes in financial position
i will be a demo of GP 10 on Weds for a customer who has a requirement for a statement of changes in financial position. Is there any reason that this would be a problem in FRx as long as i know what GL accounts make up each row? Their sales and receivables are going to be maintained in another systmer - with that system providing a journal entry either weekly or monthly. THanks! Andrea: How did this come out for you, also have you done a Schedule of Changes Report?? Pretty standard non-profit reports. "Andrea Smiley" wrote: > i will be a demo of GP 10 on Weds for a cus...

Configuration restarts each time an Office module is opened
Hi All I am going quite mad. I have installed Microsoft Office Home and Student 2007 on one Vista notebook. Well and good. I try it on another notebook, register it successfully and now each time I open Word it tries to perform a setup again, with a Configuration Progress dialogue popping up. A few decades later Word appears. There is absolutely no indication what the problem may be. Any ideas are welcome. Cheers Andre Never mind. Problem solved. The registry needed manual editing. "J Andr� Labuschagn�" <technical@eduadmin.com> wrote in messa...

Corporate Name Change
How does one change the name of a stock (and symbol) when a company (such as AOL) decides to do so Wade: Select AOL from your portfolio, right click and choose "see details" You can rename it and change the symbol there. Kevin "Wade" <anonymous@discussions.microsoft.com> wrote in message news:023701c395d4$c6129da0$a401280a@phx.gbl... > How does one change the name of a stock (and symbol) when > a company (such as AOL) decides to do so Thanks ... I get an error stating the ticker is already in use. How can I get around this (is there a global ticker li...

Run two copies of Outlook with different profiles
Hello! I'm trying to run two copies of Outlook with different (outlook)profiles at the same time. Normally i can choose the profile with the /profile switch, but if there is already a copy of outlook running, this switch seems to be ignored. Any ideas how to handle this are welcome. Regards, Reinhard "Reinhard" <reinhard.spieker@bkvibro.de> wrote in message news:60a7e218.0311190408.6523100b@posting.google.com... > Hello! > > I'm trying to run two copies of Outlook with different > (outlook)profiles at the same time. > > Normally i can choose the p...

Delivery Status Notification (DSN) different if sent from outside
When my users mailboxes are full above quota and not accepting any more mail, the sender receives a differently worded DSN depending on whether they sent email to that user from an internal account (one that is part of the exchange org) or an external account (not part of the Exchange organization). The one sent to the a user that is external is much less human friendly and is causing me a problem with some scirpted automation in my app. Is there a way to make the text the same for both? Examples pasted below: Here is the if sender is internal: Your message did not reach some or all o...

changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is completely missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, the table is empty and its .err file is also blank. If the .err files do not show...

not enough memory or disk space to display or print the picture after 1st time
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I know this topic has been covered before, but not in the way I get the problem. I can open a document with a math formula or a graphic the FIRST time and it will correctly display. Any changes to the document or any subsequent openings I then get the error message, &quot;not enough memory or disk space to display or print the picture&quot;. <br><br>eMac 1.25 Gz 10.4.6, Word 2004 <br><br>Thanks. One possible cause: You're *way* behind on Tiger -- it's been at 10.4.11 for ...

Changing Exch5.5 GAL columns in Outlook client view
Sorry if the subject line is a bit cryptic; anyway, in the Outlook client, if you display the 'Address Book' you get the following columns - name, business phone, office, title, company, alias, e-mail type, & e-mail address. How do you change it so you show the display name, business, extension, cell phone, & internet email address? Basically, how/where do you change the columnar data the client sees? Thanks, Mike Lawson Mike Goto View | Columns and there u can manage views... KJ "Mike Lawson" wrote: > Sorry if the subject line is a bit cryptic; anyway, i...

Dropdown Size: How do I change?
I have a workbook and after opening it on another computer, all the dropdowns are way too wide. And how can I have them show 20 items rather than the default of 8? Thanks, Craig Right-click the dropdown and you can change the 8 to any other number. To make it less wide, right-click it and drag the right/left border to the size you want. It MAY have something to do with the screen resolution on the other computers...? Bob Umlas "Craig Roberts" <Somewhere @ Lindstrom Minnesota USA> wrote in message news:e4jiOnVPFHA.1268@TK2MSFTNGP14.phx.gbl... >I have a workbook a...

How can I change primary display for presentation on multiple mon.
I want to hit F5 and have my presentation go to a different monitor. I have multiple monitors so my laptop display on a classroom screen. Can I change the default monitor that F5 points to? In article <5A95BBFC-B291-4A05-9E71-3F094B937ABB@microsoft.com>, Shorebilly wrote: > I want to hit F5 and have my presentation go to a different monitor. I have > multiple monitors so my laptop display on a classroom screen. Can I change > the default monitor that F5 points to? In the Slide Show | Set up show dialog, you can choose the monitor you want to display slide s...

CRM Time Error
Hi, The dates stored in the DB in sql Server is diffent, from when you browse it throghe IE. Correct dates shows in IE, but not in SQL DB. I am generating a Birthday Reminder which is not coming in the correct date since time in DB is Incorrect. Please Help..... Irshard Zahir Hi Irshard, The dates in the database are converted to the local date of the user. The problem can be tackeled by using the CRM SDK. Hopefully this works if not please let me know. Regards, Ron "Irshard" <Irshard@discussions.microsoft.com> wrote in message news:9E7A1EC9-87E7-4B8D-8F0F-B7CFE9...

pointer changes from arrow to plussign
Somehow the pointer arrow in excel has changed from an arrow to a plus sign. How can I change it back to an a n arrow? That would depend upon where you are pointing the cursor. If anywhere on the cells portion of a worksheet, the cursor is a fat white plus sign. If pointing to menus, toolbars, sheet tabs or scrollbars the cursor should be an arrow. Are you saying your cursor "never" changes to an arrow? Gord Dibben Excel MVP On Wed, 14 Apr 2004 19:15:34 -0700, "gmohanco" <anonymous@discussions.microsoft.com> wrote: >Somehow the pointer arrow in excel has c...

different versions in visio ole-object?
hello i have some problems printing a word document which includes some visio drawingns. In word i can see the visio object like i edited it but when printing the word-document, a completly old version of the visio object is printed out. The printed object is older that 2 weeks. I tryed printing the document from other PC without changes. I tryed copying the ole-object into an other word dokument (copy/paste) without changes. Printing the document from wordpad works great .... I also opened the visio object (doublecklick in word) and edited the object, saved the file and exited back to wo...

How to stop outlook resending attachments multiple times
When I send an email with an attachment, it will send several times before I manually have to stop it. Does anybody have any suggestions on how to rectify the problem? "fisco" <fisco@discussions.microsoft.com> wrote in message news:F793C1E7-AE4D-45F7-BCA6-98C570F2F915@microsoft.com... > When I send an email with an attachment, it will send several times before > I > manually have to stop it. Does anybody have any suggestions on how to > rectify > the problem? Sorry, but this newsgroup is for questions about Access, the database product tha...

Difference 05-21-04
What is the difference between CRM standard and professional? -Johnny Johnny wrote: > What is the difference between CRM standard and professional? > > -Johnny Does it have anything to do with Outlook integration? -- - I am Johnny! Your Internet penpal. I have a scooter, how about you? "Johnny" <alphascooter-verizon@yahoo.com> wrote in message news:evfBJNwPEHA.3708@TK2MSFTNGP10.phx.gbl... > Johnny wrote: > > > What is the difference between CRM standard and professional? > > > > -Johnny > Does it have anything to do with Outlook inte...

changing the message list in outlook 2003
i just upgraded from office 2000 to 2003. in the message look in outlook, it separates the messages by date. is there any way to turn this off, so i just have a long list of messages? Right click on the header in the message list, uncheck "show in groups." --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Lee Benningfield asked: | i just upgraded from office 2000 to 2003. in the mess...

Multiple Accounts held at the SAME Institution with DIFFERENT logons
I am trying to sync Money 2006 to my Banc of America Investment Services accounts. I have two accounts with two DIFFERENT logons, an IRA and a regular brokerage. Money will sync fine to one or the other, but I can't set it up to sync to both because when I click on Online Services it is already setup so I can't add a different login, etc. -- Daniel Blackmon Project Lead - Software Engineer Worldwide Environmental Products Inc. In microsoft.public.money, Daniel wrote: >I am trying to sync Money 2006 to my Banc of America Investment Services >accounts. I have two accounts w...