Convert UTC time to local timezone



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:




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




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:


service_jobs.xlsx (54.0 KB)

closed #4