How do I change the format of the time in a “TIME” column type?
I have my google sheet database formatted so it shows time as 9:00 AM, 11:00 AM, 1:00 PM and so on. In AppSheet, however, time is in the format 6:15:00 AM, 9:30:00 AM, etc. I’m looking for a way to format the “TIME” column in AppSheet, the same way it is formatted in my Google Sheet. Any and all suggestions are greatly appreciated!