Export CVS file has 24 hr format, I want AM/PM format

[diyorapiyush]

Hi there, 

My appsheet table has a Date time Column. In the app as well as in the sheet, the date time column display time in AM/PM format, however, when I export the table in CVS format. the date time column display time in 24 hour format. Is there any work around to display AM/PM format?  

[Suvrutt_Gurjar]

One option is to use Appsheet TEXT() function to convert the the time in textual AM/PM format in another column and use that column in CSV export view instead of the time type column. So even if any changes happen at server level to 24 hrs format while conversion, the textual format will not change.