Forum Discussion

Iron Contributor

Oct 25, 2024

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...

ITALIANDATETIME.xlsm40 KB

Macros and VBA

VaughnRamsey

Iron Contributor

Mar 13, 2025

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.

Gianni_Lupindo
Iron Contributor
Mar 13, 2025
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
Gianni_Lupindo
Iron Contributor
Mar 13, 2025
Be careful: there is a period in March and another one between October and November where the time differences are between PDT (UTC-7) and CET (UTC+1), so 8 hours!