Forum Discussion
Weatheramsey
Apr 02, 2022Copper Contributor
Change military time to local time if part of a formula?
I have api data getting drawn into excel regularly with time formatted as the following "2022-04-08T14:00:00-05:00". I would like to make a chart with these times on it but I want it to be shorter ...
SergeiBaklan
Apr 02, 2022Diamond Contributor
In addition, you may consider Power Query option where such transformation are doing practically natively, like
The latest column is transforming datetime from UTC-5 into my local time zone.