将MS转换为秒

本文介绍了将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.