Tags: convert, est, example, excel, formula, gmt, london, microsoft, msdn, software, time, york, zones

Formula to convert time zones?

On Microsoft » Microsoft Excel

1,512 words with 2 Comments; publish: Thu, 22 May 2008 07:03:00 GMT; (306109.38, « »)

Hello - I wanted to convert time zones, for example from New York (EST) to

London (GMT) - is there a formula out there for me to use? I would like to

just time in a time and Excel will automatically convert. Using Excel 2003

Thanks.

All Comments

Leave a comment...

  • 2 Comments
    • Well, it's just a matter of adding or subtracting so many hours, isn't

      it? EST is 5 hours behind GMT, so if you enter GMT time in A1, put

      this in B1:

      =A1-5/24

      to get EST in B1. Format both cells in time format.

      Hope this helps.

      Pete

      On Aug 1, 2:46 pm, Anna <A....excel.todaysummary.com.discussions.microsoft.com> wrote:

      > Hello - I wanted to convert time zones, for example from New York (EST) to

      > London (GMT) - is there a formula out there for me to use? I would like to

      > just time in a time and Excel will automatically convert. Using Excel 2003

      > Thanks.

      #1; Thu, 22 May 2008 07:04:00 GMT
    • If you've got New York time in A2 and the offset of New York from London in

      B1 in hours (currently -5), then use

      =A2-B$1/24

      [Remember also that London is not currently on GMT, but on BST, which is

      GMT+1.]

      --

      David Biddulph

      "Anna" <Anna.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:F1C5EDAB-62AA-4D51-A72D-7C94D2F7A968.excel.todaysummary.com.microsoft.com...

      > Hello - I wanted to convert time zones, for example from New York (EST) to

      > London (GMT) - is there a formula out there for me to use? I would like to

      > just time in a time and Excel will automatically convert. Using Excel 2003

      > Thanks.

      #2; Thu, 22 May 2008 07:05:00 GMT