Thread: Time conversion
View Single Post
  #1   Report Post  
PivotMan
 
Posts: n/a
Default Time conversion

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.