将MS转换为秒 [英] Converting MS to Seconds

问题描述

我发现这个公式用于将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.

这篇关于将MS转换为秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！