Notifications
Clear all
Excel Dashboards
3
Posts
2
Users
0
Reactions
87
Views
Topic starter
Hi,
May I know how to convert date and time data to another time zone in Excel in which the raw data is being extracted into Pivot Table.
Example:
Raw Data: In Europe Time Zone
Converted Raw Data: In Asia Time Zone
Thank you.
Posted : 28/09/2018 7:15 am
Hi Safirah,
You can add a column to your table and use a formula to add the time difference in hours to your Europe time, thus returning the Asia time. e.g. if the Europe time is in cell A2 and Asia is 5 hours ahead it would be:
=A2+TIME(5,0,0)
Mynda
Posted : 28/09/2018 7:25 am
Topic starter
Hi Mynda,
Thank you very much for your quick response. It helps a lot.
Posted : 28/09/2018 7:34 am
