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.


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

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

Thanks BenjiLop!
Also, is it possible to retain the date in that cell without it going
to 01/00/00?
I have a combination in the cell of date and time at present and the
time is all that I wanted adjusted. For Example: 03/11/06 07:36:00 AM
in PST. I would like for it to appear as 03/11/06 10:36:00 AM for my
EST use.


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

If you have date and time you only need

=A1+1/8


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

PERFECT !!!!!!!
Thanks daddylonglegs, that works just great.


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