=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)
"PivotMan" wrote in message
...
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.
|