I am trying to compute differece, but failing
Datetimes are pasted and format is assigned.
How to accomplish?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
The error indicates that the values are not datetimes but text strings that look like datetimes.
Set File > Spreadsheet settings > Locale so that the date and time formats used by the spreadsheet match those of your data, then repaste the data.
See this answer for an explanation of how date and time values work in spreadsheets.