formula for shifts from times
 

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

formula for shifts from times
 

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

formula for shifts from times
 

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

"jcontrer" wrote:

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