Change time format from 17:30 to 5:30 PM

[cbrigham]

Hello,

I have a mobile app to keep track of hours for 3 different agents I work for.

In the app, before I export the data to csv format and then to Excel, I choose the date and time by spinning a "Picker Wheel". First I spin ONE wheel which contains the "abbreviated day" , "abbreviated month" then numeral. "Tue Feb 14" (all on one wheel). The next wheel is for hour "5" and then another separate wheel to choose the minutes "30". The last wheel is "AM or PM". Tue Feb 14 5:30 PM. In the app, I have set the preference for time format to 12-hour. When I export the data to csv format the hours are converted to 24-hour time 2/14/2023 17:30. I then save the csv as an Excel file .xlsx.

On the Excel spreadsheet, is there a way to format the columns to convert the time from 24-hour to 12-hour time showing the AM/PM? Below is an example:

Thank you.

[#2 · Accepted solution]

@cbrigham 

Select the cells and set the number format to the custom format

m/d/yyyy h:mm AM/PM

[#3]

It worked. Thanks so much!