Time Format on Spreadsheet

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.

0 1 111
1 REPLY 1

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

Top Labels in this Space