Forum Discussion
Converting a USA-formatted date with PST/PDT into an Italy-formatted date with CET/CEST
When you import comma-separated values (CSV files) into an Excel sheet, the dates are formatted according to your operating system settings. Unlike manually entered values, imported dates whose forma...
The time difference between PST (UTC-8) and CET (UTC+1) is 9 hours, and between PDT (UTC-7) and CEST (UTC+2) it is 9 hours as well. Note that the adjustment may vary depending on daylight saving time, so ensure you account for that when converting.
Below is a method to do this using a combination of Excel formulas. You can also use a VBA function if you prefer a more programmatic approach.
In this moment, today March 13, 2025, in Los Angeles (USA) it's 1:00 PM (PDT, UTC-7) while in Rome (Italy) it's 9:00 PM (CET, UTC+1), so the time difference is 8 hours; so it will be also between the last Sunday of October in Rome and the first Sunday of November in Los Angeles. https://www.worldtimeserver.com