I have read a few posts about Date/Time formatting, but my issue is more about displaying the local date/time instead of the “server US” time.
Here is an example.
When a purchase is made, a date/time entry is added to the sheet, as highlighted below.
When I format and display the time it’s displayed in the app as such, 2:06AM which clearly is not early in the morn here in Aus .
The spreadsheet settings are already set to my local time
some additional info, I have a work-around to using Glide’s cart feature to identify all purchased items in a single order (unique and the same for all items purchased in the order) by looking at the recorded date/time in the App:Sales as per above screenshot. And I use the last 6 char as the order reff eg; 08.625Z
so I don’t want to reformat the cells, but rather simply display the recorded date/time by Glide which appears to be US and convert that to my local time.