This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 02-02-2018 04:00 PM
Brady_Lovell
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

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!

0 2 314
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Stephen_Mattiso
New Member
Reply posted on --/--/---- --:-- AM

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.

0 Likes

Posted on --/--/---- --:-- AM
Brady_Lovell
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

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

0 Likes
Top Labels in this Space