Sleeper: Dates and times

I have a spreadsheet that I need to fix.

The attached file is all messed up.

The finished product should have 2 columns as it does now. Except it should both be in PST time zone. Right now the right most column is in EST time zone.


Any quick fix out there?

Thanks so much for helping!

Amanda

Hi Amanda,
Welcome to VBAX.
Your file contains the two columns, but are they related? What are you wishing to enter in the column to show the time? Is it the current time when you do some action?