Ask Your Question

timezone adjustments

asked 2015-05-19 19:35:14 +0200

glitch256 gravatar image

updated 2016-03-09 21:12:18 +0200

Alex Kemp gravatar image

i have a spread sheet that i need to do caluations with mutiple timezones and those time zones can and will change. master user will set master time/date/timezone and the frequently changing user will supply their time zone. how do i get the spreadsheet to grab the right cell/differental so the user will be given the right time to be availble?

ubuntu 15.04 libreoffice english

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-05-20 03:19:31 +0200

ROSt52 gravatar image

updated 2015-05-20 03:26:09 +0200

I checked in the help file and help wiki and did not find anything related to timezone considerations.

I am afraid you need to enter timezone information manually and than adjust formulas depending on the timezone used.

I recommend to also have a look at the free guides, which you can download from

These links might be helpful:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-19 19:35:14 +0200

Seen: 1,108 times

Last updated: May 20 '15