Formula to convert time zones??
 

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.

Answer: Formula to convert time zones??
 

Yes, there is a formula you can use in Excel to convert time zones. Here are the steps:

1. First, you need to know the time difference between the two time zones. For example, New York is 5 hours behind London.
2. In Excel, you can use the formula
   Formula:

   ---

   =A1+time(hours,minutes,seconds) 


   ---

   to add or subtract time from a given cell. In this case, you would use the formula
   Formula:

   ---

   =A1+time(5,0,0) 


   ---

   to add 5 hours to the New York time.
3. To make this formula more dynamic, you can use cell references instead of hardcoding the time difference. For example, if cell A1 contains the New York time and cell B1 contains the time difference (in hours) between New York and London, you can use the formula
   Formula:

   ---

   =A1+time(B1,0,0) 


   ---

   to convert the New York time to London time.
4. You can also use the TEXT function to format the result as a time. For example, the formula
   Formula:

   ---

   =TEXT(A1+time(B1,0,0),"h:mm AM/PM") 


   ---

   will convert the time and display it in the format of "1:30 PM".

Formula to convert time zones??
 

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 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.

Formula to convert time zones??
 

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" wrote in message
...
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.