Forum Discussion
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 ...
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.