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!
If it is just a Time column then you can choose to Omit seconds, but if it is a timestamp column then you can not omit seconds.
@Stephen_Mattison Not sure how I looked over this, thanks for pointing this out!
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |