Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert EST to PST in formula (Excel - Office XP)

    I would like to be able to convert a column of Eastern Std. Time entries to Pacific Std. Time (or Daylight -- doesn't matter) using a formula that I can duplicate down the column with RELATIVE values. I know that I can enter ="19:00"-"3:00" (19:00 is EST, 3:00 is the difference between EST and PST) and have the result show 16:00, but then duplicating down doesn't take into account the different times in the EST column. What formula can I use?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert EST to PST in formula (Excel - Office XP)

    If the times are in column A, starting in row 1, then put the formula below in row 1 of an empty column and copy down as far as necessary.

    <code>
    =A1-TIME(3,0,0)
    </code>
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Jul 2004
    Location
    San Mateo, California, USA
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert EST to PST in formula (Excel - Office XP)

    Legare -- Many thanks. I'd tried the help menu and it didn't seem to be there. I would never have thought of the "TIME(3,0,0)" part of the formula!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •