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