Convert to EST time from PST time

[bobpic]

I have columns that look like below.. How can I easily convert them to PST from EST..

Thanks

10:00:00 AM
10:00:00 AM
4:00:00 PM
4:00:00 PM
5:45:00 PM
6:15:00 PM

 

[Joe4]

If your time was in cell A1, simply use the formula:

=A1+(3/24)

 

[Andrew Poulsom]

Assuming EST is PST minus 3 hours, enter 03:00 in a spare cell and choose Edit|Copy. Select your list of times choose Edit|Paste Special, check Subtract and click OK.

Edit - I guess it should be check Add instead of Subtract (EST is PST + 3 hours)

 

[Tom Urtis]

Based on the locked duplicate posts here...

http://www.mrexcel.com/board2/viewtopic.php?t=135122
http://www.mrexcel.com/board2/viewtopic.php?t=135365

...here are a couple ways to do this if you really still do not have an answer.


If these values are in one column starting in A1, then...

Non-VBA:

In another cell (B1 or wherever) enter the formula
=A1+TIME(3,,)
and copy down as needed.



VBA:

Sub Test1()
Application.ScreenUpdating = False
Dim LR As Long
LR = Cells(Rows.Count, 1).End(xlUp).row + 1
With Range("B1:B" & LR)
.Formula = "=RC1+TIME(3,,)"
.Value = .Value
End With
Columns(2).AutoFit
Columns(1).Delete
Application.ScreenUpdating = True
End Sub