1 microsoft second = 0.00001157407407 [英] 1 microsoft second = 0.00001157407407

问题描述

我刚刚发现了MS Excel电子表格，

1 microsoft second = 0.00001157407407

  1/1/1900 0：00：01.000 1.000011574 
 1 / 2/1900 0：00：02.000 2.000023148 
  

为什么？

为什么不是0.00001或更多的数字？

有什么意义0.00001157407407？

二进制值= 0.00000000000000001100001000101110

解决方案

在Excel中，每一天都以1.0表示，值为1.0等于1月1900年1月1日（即：这是自12/31/1899以来的日子，如果你在1900年2月之后，再加一个）。

您发布的号码，实际上 1天/（24 * 60 * 60）或 1/86400 == 0.00001157407407 。

I was writing a routine to read from an Excel spreadsheet.

I have just discovered thro that MS Excel spreadsheet that

1 microsoft second = 0.00001157407407

1/1/1900 0:00:01.000    1.000011574
1/2/1900 0:00:02.000    2.000023148

Why?

Why not 0.00001, or some rounder number?

What is the significance of 0.00001157407407?

Binary value = 0.00000000000000001100001000101110

解决方案

In Excel, each day is represented by 1.0, with a value of 1.0 being equal to January 1st, 1900 (ie: it's effectively the days since 12/31/1899, plus one if you're after Feb 1900).

This works out to each second being the number you posted, which is effectively 1 day / (24 * 60 * 60) or 1 / 86400 == 0.00001157407407.

这篇关于1 microsoft second = 0.00001157407407的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！