将MS转换为秒
我发现这个公式用于将MS转换为秒，但是它是为Excel 2002编写的，而我正在使用2010年。
I found this formula to use to turn MS into Seconds but it was written for Excel 2002 and i am using 2010.
=CONCATENATE(TEXT(INT(B1/1000)/86400,"hh:mm:ss"),".",B1-(INT(B1/1000)*1000))
以下是我要从MS到Seconds的几个例子
Here are a few examples of what I am trying to take from MS to Seconds
25188
59125
64092
19115
26416
我会说实话，我不是很好的Excel公式，所以任何帮助将是伟大的。我已经拍摄了上述公式所导致的错误。
I will be honest i am not very good with Excel formulas so any help would be great. I have taken a screen shot of the error that i am getting with the above formula.
它在Excel 2010中正常工作。将此公式放在单元格B1中。
It works fine in Excel 2010. You just can't put this formula in cell B1.
如果您将B1中的数字和该公式放在任何其他单元格中，它将工作。
If you put a number in B1 and this formula in any other cell, it will work.
您得到一个循环引用警告，因为公式是指单元格B1，它是公式所在的单元格。
You're getting a circular reference warning because the formula refers to cell B1, which is the cell the formula is in.