Ask Your Question

timezone adjustments [closed]

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

glitch256 gravatar image

updated 2020-07-27 15:14:44 +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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-27 15:15:06.405426

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

Question Tools

1 follower


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

Seen: 1,400 times

Last updated: May 20 '15