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