Sorry, I still have a few errors, I will give you actual data:
0017 GMT 8
0045 GMT 1
0256 GMT 11
0856 GMT 10
0902 GMT 13
0154 GMT 5.5
For the above I get #######, for all other records I get the correct answers.




"fruitchunk" wrote:

Ok, I think I figured it out:
=TEXT(A1,"00\:00")-(RIGHT(B1, LEN(B1)-3)+5)/24
seems to be working fine.

Thanks again.

"fruitchunk" wrote:

I still have a problem with times that are not -GMT for example:
0303 GMT 11

Thanks

"Ron Rosenfeld" wrote:

On Thu, 12 Nov 2009 14:53:01 -0800, fruitchunk
wrote:

I get a text feed with some data, in Column A I have the time (as text) in
Column B I have the timezone. How can I get EST in the next coulmn?

Example:
CELL A1: 1649
CELL B1: GMT -6
In CELL C1 I would like to see 5:49 PM

Thanks

=TEXT(A1,"00\:00")-(MID(B1,FIND("-",B1),4)+5)/24

Note the last "5" in the sequence. That is the difference between GMT and EST.
--ron
.