I need to calculate Dates from one date I read from a Excel, the problem is that for example, if I read 31/10/2021 02:00:00 and I add 1 hour, it should give me back again the same hour, because there is time change so at 03:00:00 would be again 02:00:00, the problem is that when I read from excel 31/10/2021 02:00:00 the date is created with CET, so if I add the hour it would show 03:00 instead of 02:00:00 that is what I need.
I´m using java Calendar with the date I read from excel and then adding 1 hour to calendar. Any idea how should I do so its repeats again 02:00 because of the daylight saving?