Forum Discussion
Solved
Excel will not subtract times with decimal seconds.
The attached XLSX file has times with decimal seconds in column A. The format for these is hh:mm:ss.000 (to attempt to show "eleven oh four and 44.607 seconds" in cell A3). While I believe the time...
It's a wild guess, but try setting the Short Date format to yyyy-mm-dd or yyyy/mm/dd.
If it doesn't help, simply set it to yyyy.mm.dd again.
You guys have been a great help, but alas...
I get the same behavior with "excel /safe" (but I learned something new - didn't know about this).
I may have an unusual system date format for the USA, but it's certainly not unreasonable. Here's everything:
It's a wild guess, but try setting the Short Date format to yyyy-mm-dd or yyyy/mm/dd.
If it doesn't help, simply set it to yyyy.mm.dd again.
- Wild? Yes! Correct? Yes!
Excel was apparently interpreting the input as a date, even though I custom formattted it as a time.