lsmft Wrote:
Is it possible to have excel convert the time automatically?
I keep a worksheet on Ebay items on which the list the
end-date/end-time in Pacific Standard Time. I need it in Eastern
Standard Time. I'd like to be able to enter their PST time in a cell
but have it appear in EST. If not automatically, how should I
compensate for hours only in another cell?
Thank you.

One way ...

With PST entered in Cell A1, enter this formula in Cell B1,

=MOD(A1+(3/24),1)

Hope this is what you need.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=521362