ExcelBanter - Time conversion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time conversion (https://www.excelbanter.com/excel-worksheet-functions/50275-time-conversion.html)

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.

=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.