Date Conversions from UTC to EST

[Kosher Kitten]

I was wondering whether anyone would know how to convert a UTC (Coordinated
Universal Time ) into a date which is in EST (Eastern Standard Time) or a
date which is in PST (Pacific Standard Time).

For example:

I have a UTC time of 1109366276 <-- this is the number in UTC time or
number of seconds since 1/1/1970

What would be the formula I could put into the next column to change the
above number into a PST or EST date/time?

 

[Peo Sjoblom]

=A1/86400+DATE(1970,1,1)

where A1 holds 1109366276

To get EST deduct 5 hours, to get PST deduct 8 hours
gives

=A1/86400+DATE(1970,1,1)-(5/24)

for EST

note you need to format the result as date and time or else you get
a serial number so use a custom format like

m/d/yy h:mm