How do I Convert TEXT to EST Time ?
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
.
|