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.
Is it my machine?
I did what you said and all it did was delete the data in columns B:F... and no, the formulas still do not work.
Thank you for your help!
I did what you said and all it did was delete the data in columns B:F... and no, the formulas still do not work.
Thank you for your help!
This is what I got:
- The problem is apparently with my machine... or should I say registry?
This solution apparently works on every other machine tested. I was advised to uninstall Office 365 and then reinstall. This did not correct the problem for me, leading me to think there is some setting 'stuck' in the registry.
Anyone who might know how to correct the issue on my machine are invited to comment!To be sure, what are you list, thousand and decimal separators on this machine?
- File > Options > Advanced has a period "." for a decimal and a comma "," for thousands. The Windows 10 OS is the same. I'll try swapping this to European style on a working machine and see if it still works...
