formula for shifts from times

  • Thread starter Thread starter jcontrer
  • Start date Start date
J

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.
 
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
 
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
 
Back
Top