How to convert UTZ to Local DTG in Excel

Tips and tricks, articles, and related material.
Post Reply
jhummer
Posts: 1168
Joined: Wed Mar 17, 2010 2:49 pm

How to convert UTZ to Local DTG in Excel

Post by jhummer » Tue Apr 02, 2019 8:51 am

With BI360 cloud the date will record in a data center time to see it local you have to convert it.

Use this formula. =LEFT(B8,LEN(B8)-4)+TIME(10,0,0) The B8 is the UTZ or data center time and plus the time difference
Attachments
Excel Convert UTZ to Local.jpg
Excel Convert UTZ to Local.jpg (28.6 KiB) Viewed 126 times

Post Reply