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. ...
One important note: After I applied the s:000 formatting, the cells looked like they were in seconds. However, when I was doing some time delta/acceleration calculations, the answers looked very small, on the order of e-6. I realized that although the format was s:000, Excel still saw that as a day, and there are 86,400 seconds in a day. So a little math straightened that issue.