What i have: A very long column entered in the HH:MM AM/PM format in pacific
standard time (PST).
eg. 4:15 AM.

What i need:
1. I need those times to be changed from pacific standard time (PST) to
Eastern standard time (EST)
2. and then those hours to be changed into shifts (via Formula?)
My shifts a
Shift 1 = 8:00 AM to 4:00 PM
Shift 2 = 4:00 PM to 12:00 AM
Shift 3 = 12:00 AM to 8:00 AM

I would greatly appreciate any help.
--
thanks in advance