Forum Discussion
Gianni_Lupindo
Oct 25, 2024Iron Contributor
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...
VaughnRamsey
Mar 13, 2025Iron Contributor
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
Mar 13, 2025Iron Contributor
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!