Forum Discussion

Weatheramsey's avatar
Weatheramsey
Copper Contributor
Apr 02, 2022

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 ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 02, 2022

Weatheramsey 

You may transform text to time with TIMEVALUE(), e.g.

=TIMEVALUE("14:00")

and apply to the result any desired time format

 

  • Weatheramsey's avatar
    Weatheramsey
    Copper Contributor
    Apr 02, 2022
    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"
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 02, 2022

      Weatheramsey 

      Select cell(s), Ctrl+1, custom number format and use h AM/PM

Resources