Convert UTC time to local timezone

Power Query
1

Greetings,

i was just wondering if anyone has some pointers for converting utc to local timezone; doing my head in a bit at the moment :slight_smile:

Cheers

2

@melgar

This can be done pretty easily in Power Query as it has functions specifically for this. Have you tried there? If you want, post some sample data and we can walk through it

Enterprise%20DNA%20Expert%20-%20Small

3

@Nick_M

thanks for the offer, most appreciated, i have attached a sample of the data set, nothing special just a basic ticketing system. I have has a fish around in Query Editor but lost myself, cant see the forest for the trees now :slight_smile:

Cheers

service_jobs.xlsx (54.0 KB)

6

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.