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