anyone, please tell me how to convert the time format in AppSheet like this 12.00.00 to this 12:00:00. i need it because I can’t work on my spreadsheet for time value.
So you already have multiple records with the sytnax as 12.00.00?
If so, what I’d do would be to use Find & Replace in the spreadsheet on that columns to replace all . with : Then go into Appsheet and set the column as a Time type column
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |