Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 132
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.
#2
 Excel Super Guru Posts: 1,867
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".
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 8,856
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.

#4
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 8,651
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Calculate Date range Excel Worksheet Functions 1 April 20th 06 08:47 AM Cactus-747 Excel Discussion (Misc queries) 1 April 14th 06 06:11 AM Paul Excel Discussion (Misc queries) 1 August 4th 05 08:14 AM Aaron Excel Worksheet Functions 1 March 11th 05 06:17 PM tjb Excel Worksheet Functions 0 February 17th 05 03:39 PM

All times are GMT +1. The time now is 02:52 AM.