Put 3:00 in an empty cell, copy it and select the time entries
and do editpaste special and select add


or use


=A1+TIME(3,,)

or

=A1+0.125

where A1 holds the PST first time, then do the same for the other

--


Regards,


Peo Sjoblom

"jcontrer" wrote in message
...
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