Date and Time

[DEllis]

I have a column that contains date time and AM/PM (11/5/2024 10:40:54 AM) what I need is for it to read Date and 24 hour time without AM PM. So Example outcome would be (11/5/2024 10:40:54) if it was PM it would be (11/5/2024 20:40:54).

I cannot figure out how to get time correct and keep date or keep date and time disappears.

 

[Cubist]

Try format the cell as m/d/yyyy h:mm:ss

 

[DEllis]

Try format the cell as m/d/yyyy h:mm:ss

I did not see that in the custom format spot

 

[Cubist]

I did not see that in the custom format spot

Enter it manually or paste it in "Type" box.

 

[DEllis]

Enter it manually or paste it in "Type" box.

Thank you that worked!