formula for shifts from times

[jcontrer]

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 are:
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.

 

[Peo Sjoblom]

Put 3:00 in an empty cell, copy it and select the time entries
and do edit>paste 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

 

[Joel]

time is stored as a number in Excel with 1 = 1 Day. Each hour is 1/24 so to
go from PST to EST add 3 hours which is 3/24 or 1/8 or .125