</p><p>每次交作业都觉得怪怪的。</p><p>[em01]</p><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font color="#ff0000" size="3"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font color="#ff1111"><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">申明:不是老师,和你一样是学员。</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font color="#ff1111"><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">除第六题外,其他通过。</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font color="#ff1111"><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第六题的答案都不太好,第一种:日期是个序列值,由整数位(日期序列值)</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">+</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">小数点</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">+</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">小数位(时间序列值)组成。长度不定,最大</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">16</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">位。</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">Find(“”,A2) </font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">对数字操作,结果都是</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">1</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">。</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">--LEFT(A2,LEN(A2)-FIND("",A2))</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">相当于将日期序列值小数位约了一位,带小数位影响不明显。如果日期值是整数,无小数位,你的公式就把值完全改变了。把第一个日期时间改为</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">2003-12-23<span style="mso-spacerun: yes;"> </span>0:00:00</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">试试。</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font color="#ff1111"><span style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">设置格式只是改变了显示值,不符合要求的。参考学委贴出的答案,再做一做吧!</span><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman"><span style="mso-spacerun: yes;"> </span>By:<span style="mso-spacerun: yes;"> </span>L.H.<p></p></font></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"></p></font></span>
[此贴子已经被jyh197994于2008-7-3 15:45:25编辑过] |