Difficult conversion from military to standard

[Galactus]

Hello All,
I have an issue converting military time to standard time.
Had similar issue with date, and this answer helped solve it.

Tried same fix for the time, and "time" wasn't an option so there was no fix that way.
Also tried format cells, as well as making a new column but I couldn't figure out a way to get data from that column to appear in the new one with standard time.

Here is how it looks.

Any advice on how I can get the time to show up as 10:01:00PM (or AM whichever it happens to be at the time)

Thanks to all, and have a great evening.

 

[Alex Blakenburg]

Did you try it ? The first step is to convert it to a number (the left alignment is indicative of it being text).
The same steps should achieve that (both General and Date should work)
Then in number format just pick Time and your desired format which looks to be the first option.

 

[Galactus]

Did you try it ? The first step is to convert it to a number (the left alignment is indicative of it being text).
The same steps should achieve that (both General and Date should work)
Then in number format just pick Time and your desired format which looks to be the first option.

I tried the "try this" and it fixed the date column.

Time is not an option for that selection.

 

[Alex Blakenburg]

Don't worry that it is not an option. Either pick General or in date just leave the first thing that i selected and hit Finish.

 

[Galactus]

Don't worry that it is not an option. Either pick General or in date just leave the first thing that i selected and hit Finish.

I tried all those options before. Looks great in the preview section, but fails to implement it.

Still looks like this

 

[Alex Blakenburg]

You still need to apply the Time formatting.