Ask Your Question
0

convert cell timezone

asked 2015-12-03 22:02:45 +0200

mydiskdrive gravatar image

Hello, I have a column with date/utc time like: 2015-02-23 08:22:35

I would like to make another column that converts this to usa est time and another that converts it to usa pst time.

I have installed the "jave time zones" extension and can not figure out how to use it.

Can the conversion be done using a formula?

What would that formula be?

Thank you,

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-01-19 10:55:10 +0200

Unfortunately I am not familiar with the extension, but personally I would use something like this:

=A1-TIME(5;0;0)

for a UTC-5 time zone.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-12-03 22:02:45 +0200

Seen: 1,630 times

Last updated: Jan 19 '17