How do I change the format of the time in a "...

(Brady Lovell) #1

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!

(Stephen Mattison) #2

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.

(Brady Lovell) #3

@Stephen_Mattison Not sure how I looked over this, thanks for pointing this out!