Time conversion

P

PivotMan

Hello,

I have a worksheet which expresses volume (call volume) by hour in a day.
The problem is that the time is expressed in GMT and I want to convert it to
Pacific time.

So what I have is
9/1/2005 0:00 9/1/05 12:00:00 AM

and what I want is

8/31/2005 16:00 8/31/05 16:00:00 PM

Any help would be greatly appreciated.
 
B

Bob Phillips

=TEXT(--LEFT(A1,FIND(" ",A1)-1)-TIME(8,0,0),"mm/d/yyyy hh:mm AM/PM")&"
"&TEXT(--RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1)+1))-TIME(8,0,0),"m/d/yyyy
hh:mm AM/PM")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top