Forum Discussion
can't read date format
I have a spreadsheet with imported data with date format like: 2023-11-9 12:16:38:609 I can change cell format to time but istext still says yes. timevalue and datevalue functions don't work. ...
Set the number format of the cell with the difference formula to hh:mm:ss.000 or to s.000 if you only want to see the seconds.
HansVogelaar That did it! Thanks for the learning!