Can I convert the CC timestamps in Google Sheets into regular date format?
I am using a project to write sensor data from my homematic IP's temperature sensor into a google spreadsheet. This works accordingly, but the timestamp in column 1, which is automatically written, can not be recognized as "date" or "date/time" format (e.g. when creating a chart or so) by google sheets. Is there a solution to change that?