Excel not changing time format to 24 hr format [Closed]

Report
-
Hello,

I have exported ddata from ServiceNow into an Excel spreadsheet. The Created field shows as mm\dd\yyyy hh:mm:ss. I need to separate the field. I can use the Month, Day, Year functions to get the date. However if I use the Hour, Minute, Second function to get the time leading zeros are lost and I don't know if the time is AM or PM. I have tried text to column to create a field with just time and the format does not do anything when I try to change to 24hr format. I am unable to eliminate the AM/PM at the end of the data. Any suggestions would be very much appreciated

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!