Get LibreOffice Calc to interpret ISO datetime strings as dates
- libreoffice format ISO as date
- libreoffice interpret ISO datetime as local timezone
- OpenOffice ISO date standard display
Basically no. Wow. Great to have this helpful formula (in comments to answer linked below) but damn spreadsheet software should be able to automatically recognize common datetime standards if you just tell it what it is.
https://ask.libreoffice.org/en/question/1673/possible-to-have-calc-recognize-iso-8601-date-format/