Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
Yes, there is a formula you can use in Excel to convert time zones. Here are the steps:
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set a formula to convert the time zone | Excel Worksheet Functions | |||
time zones | Excel Discussion (Misc queries) | |||
How do I sort area codes by time zones | Excel Discussion (Misc queries) | |||
Does Excel support Time Zones? | Excel Worksheet Functions | |||
adding time zones to formatting | Excel Worksheet Functions |