Converting time values to a different time zone using Copilot for Excel

Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. I have a table showing a list of Meetings, including the location and time. Currently the times are for the city they are located in.

 

Table of Meetings including columns for Meeting Name, Location, City, Date and Time

 

I would like to see the times changed to be for the Pacific time zone. I ask Copilot:

 

Update the meeting times to all be in the pacific time zone based on the cities New York, Chicago, Denver and San Francisco

 

Picture of the Copilot in Excel pane showing the above prompt with the formula column suggestion to be reviewed and inserted

 

Looking at B2:F22, here's 1 formula column to review and insert in Column G:

Pacific Time

Converts the meeting times to Pacific Time by adjusting the original time based on the city where the meeting is held.

=[@Time] - IF([@City]="New York",3/24,IF([@City]="Chicago",2/24,IF([@City]="Denver",1/24,0)))

 

Hovering over the “Insert Columns” button in the copilot pane shows this preview:

 

Table of meetings with preview of a new column to be added the meeting time in the Pacific time zone.

 

The proposed formula column looks correct in the preview. I will click on the Insert Column button and I get this updated table:

 

Table of meetings with Pacific time zone added

 

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

 

Thanks for reading,

Microsoft Excel Team

 

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.