Is there an easy way to correct a long column of time entries by a specific number of hours, that is, to change the Time Zone of the entries?
Recently my data logging device was mistakenly set for UTC (old GMT) instead of the local time zone, so 7 days worth of data (some 1900 data entries) were stamped with times and dates advanced by 5 hours. I tried many things which didn’t work, and ended up creating an extra column with the corrected times using
but of course that caused some “negative” times (errors) which I had to correct manually, and of course the corresponding dates as well, manually. It took some time to do all of this, no pun intended.
In case this problem happens again, it might help to know if there is an easier (faster) way to simply correct a column of 24-hour times by an exact number of hours, plus or minus, as if changing the Time Zone of them. It would be preferable if the new times could appear in the same column as the old times, but I realize that might not be possible (REFERENCE errors) and that the layout of the spreadsheet would have to be modified to accommodate the corrected times (as I did in my own “solution”).
Using LibreOffice v22.214.171.124 under Ubuntu 20.04.