Fix Power Automate Google Calendar Time One Hour Behind in Excel
Question details
Users experience a one-hour delay when exporting Google Calendar events to Excel via Power Automate due to time zone conflicts.
- Product
- Microsoft Excel, Power Automate, Google Calendar
- Device & OS
- not provided
- Scenario
- Exporting Google Calendar event details to an Excel spreadsheet using a Power Automate flow.
- Observed behavior
- The start time, end time, and timestamp recorded in Excel appear exactly one hour behind the actual event time in Google Calendar.
Ensure you have editing access to your Power Automate flow and confirm the exact local time zone your Google Calendar and Excel workbook are supposed to use.
Use the Convert Time Zone Action in Power Automate
The most reliable way to fix the one-hour offset is to explicitly convert the UTC time to your local time zone within the flow.
Power Automate processes time in Coordinated Universal Time (UTC) by default. If your local time zone or Daylight Saving Time isn't explicitly accounted for before writing data to Excel, the timestamps will be offset.
Open your Power Automate dashboard, locate the flow that syncs Google Calendar to Excel, and click 'Edit'.
Click the '+' icon to add a new step just before the 'Add a row into a table' Excel action. Search for 'Convert time zone' and select it.
In the Base time field, select the dynamic content from Google Calendar (e.g., Start Time). Set the Source time zone to '(UTC) Coordinated Universal Time' and the Destination time zone to your actual local time zone.
In your Excel action step, replace the original Google Calendar time dynamic content with the 'Converted time' output from the new conversion step. Save and test your flow.
Verify and Align Time Zone Settings Across Platforms
Mismatched time zone settings between your Google account, Microsoft account, and local system can cause unexpected shifts, especially during Daylight Saving Time.
Experience Hassle-Free Data Management with WPS Office
While Power Automate and Microsoft Excel synchronization can sometimes lead to complex time zone and formatting issues, WPS Office offers a streamlined, standalone Spreadsheet alternative. Fully compatible with Microsoft Excel formats, WPS Office provides intuitive data formatting tools without the heavy overhead.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing Microsoft Excel workbooks without losing any formatting.
- 3. Manage Data Intuitively: Use built-in date and time functions to manage your schedule data without relying on complex external automated flows.
Frequently Asked Questions
Why does Power Automate export dates in UTC?
Power Automate standardizes date and time values using Coordinated Universal Time (UTC) to prevent conflicts across global servers and interconnected cloud services. It requires explicit conversion actions to display your local time.
Can Daylight Saving Time (DST) cause this one-hour difference?
Yes. If your Google Calendar correctly adjusts for DST but your Excel environment or Power Automate flow does not (or uses a fixed timezone offset), a one-hour discrepancy will appear during the affected months.
How do I format the converted time to look exactly how I want in Excel?
In the Power Automate 'Convert time zone' action, you can select a specific 'Format string'. Choose a standard layout from the dropdown or input a custom string like 'yyyy-MM-dd HH:mm' so the output matches your desired Excel layout perfectly.
