0

I am trying to compute differece, but failing

enter image description here

Datetimes are pasted and format is assigned.

How to accomplish?

1
  • The question cannot be conclusively answered without seeing your spreadsheet settings. Consider sharing a publicly editable sample spreadsheet with realistic-looking data. – doubleunary Jul 14 at 8:39
0

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.

2
  • Can I do without repaste? Can I reinterpret existing text? – Dims Jul 14 at 9:44
  • Sure. Consider sharing a publicly editable sample spreadsheet with realistic-looking data. – doubleunary Jul 14 at 20:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.