View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
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.