Converting EST to PST

[Guest]

I would like to convert Eastern Standard Time to Pacific Standard time. In
other words, add 3 hours to a time formatted as hh:mm.
I haven't had any luck even after reading all the TIME information. What am
I missing?
Thanks

 

[Arvi Laanemets]

Hi

=PST+TIME(3,0,0)


Arvi Laanemets

 

[Myrna Larson]

If the original time is Easter, you must SUBTRACT 3 hours to get Pacific, not
ADD. If the Eastern time is in A1 =A1-3/24 or =A1-1/8

 

[Guest]

Thanks Myrna.
That did it for me. Appreciate the help. Now I can program my VCR to tape
the NASDAQ 100!
Neil