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 ...
Thank you! That worked. It now displays "2:00 PM". But is there a way to display the time value showing only the hour without the minutes? "2 PM"
