Title: Read datetimes expressed as UTC+offset (no DST) in R
Tags: r;datetime
Question: I have to read in R an excel file with a datetime field expressed as UTC+01 (so an offset of 1h from UTC and no DST).
I want to take into account the offset and join this dataframe with another one where datetime is expressed as locale (same 1h offset from UTC but with DST).
I would like to have the resulting dataframe with datetimes in locale.
Comment: It's easier to help you if you include a simple [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) with sample input and desired output that can be used to test and verify possible solutions.


Here is another answer: The lubridate package may be useful.
library(lubridate)
x <- ymd_hms("2009-08-07 02:00:01")
#[1] "2009-08-07 02:00:01 UTC"
hour(x) <- hour(x) + 1
#[1] "2009-08-07 03:00:01 UTC"

{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 1, 'CommentCount': 1, 'ContentLicense': 'CC BY-SA 4.0', 'CreationDate': '2019:00:12/16/19', 'FavoriteCount': 1.0, 'PostTypeId': 1, 'Tags': '<r><datetime>', 'Title': 'Read datetimes expressed as UTC+offset (no DST) in R', 'ViewCount': 32, 'id': 59360311, 'user_AboutMe': None, 'user_AccountId': 1917464.0, 'user_DisplayName': 'EanX', 'user_Reputation': 415.0, 'user_Views': 32.0, 'user_id': 1729759.0}}