Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time conversion GMT to Pacific | Excel Discussion (Misc queries) | |||
Time conversion | Excel Discussion (Misc queries) | |||
Text to time conversion | Excel Discussion (Misc queries) | |||
Time Conversion question | Excel Discussion (Misc queries) | |||
Excel Time Conversion | Excel Discussion (Misc queries) |