Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set a formula to convert the time zone Calculate Date range Excel Worksheet Functions 1 April 20th 06 08:47 AM
time zones Cactus-747 Excel Discussion (Misc queries) 1 April 14th 06 06:11 AM
How do I sort area codes by time zones Paul Excel Discussion (Misc queries) 1 August 4th 05 08:14 AM
Does Excel support Time Zones? Aaron Excel Worksheet Functions 1 March 11th 05 07:17 PM
adding time zones to formatting tjb Excel Worksheet Functions 0 February 17th 05 04:39 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"