Time Zone Adjustments

[lsmft]

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.

 

[BenjieLop]

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.

 

[lsmft]

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.

 

[daddylonglegs]

If you have date and time you only need

=A1+1/8

 

[lsmft]

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