接力赛：时之差

dengyf

SUBSTITUTE(SUBSTITUTE(TEXT(SUM({1,-1}*(TEXT(LEFT(A2:B2,FIND("天",A2:B2&amp;"天")-1),"0;;;!0")+RIGHT(SUBSTITUTE(SUBSTITUTE(A2:B2,"小时",),"天","00"),2)/24)),"[&gt;=1]0天?/24;[&gt;0]?/24;"),"/24","小时"),"&#160;&#160;&#160; ","天")<br/>195个字符<br/>

qinqh_yl

<p>学习"<strong><font color="#61b713" face="Verdana">dengyf<font color="#000000">"的公式!</font></font></strong></p><p><strong><font face="Verdana">公式中的[&gt;0]用[&gt;]还可省一个字符.</font></strong></p>

一剑惊心

<p>截止到8-24 19：00（最短公式为196个字符，各位高手继续出手啊）</p><p><br/></p><p>qinqh_yl 版主只提供思路，未写公式，不好意思，只能给10个BB</p><p>[em01]</p><p></p><p></p>

wjh619993018

<p>不是有意灌水，是写错公式了</p>

[此贴子已经被作者于2010-8-24 21:32:46编辑过]

wjh619993018

<p>错了！哈哈</p>

[此贴子已经被作者于2010-8-24 21:22:57编辑过]

wshcw

很烦琐的题目.

chunlin1wang

<p>加等号195</p><p>=SUBSTITUTE(SUBSTITUTE(TEXT(SUM((TEXT(LEFT(A2:B2,FIND("天",A2:B2&amp;"天")-1),"0;;;!0")+RIGHT(SUBSTITUTE(SUBSTITUTE(A2:B2,"小时",""),"天","00"),2)/24)*{1,-1}),"[&gt;=1]0天?/24;[&gt;]h小时;"),"/24","小时"),"&nbsp;&nbsp; ","天")</p>

dengyf

加等号<br/>=SUBSTITUTE(SUBSTITUTE(TEXT(SUM({1,-1}*(TEXT(LEFT(A2:B2,FIND("天",A2:B2&amp;"天")-1),"0;0;;!0")+TEXT(RIGHTB(SUBSTITUTE(A2:B2,"小时",),2),"0;0;;!0")/24)),"[&gt;=1]0天?/24;[&gt;]?/24;"),"/24","小时"),"&#160;&#160;&#160; ","天")<br/>192字符<br/>

dengyf

加等号<br/>=SUBSTITUTE(SUBSTITUTE(TEXT(SUM({1,-1}*(TEXT(LEFT(A2:B2,FIND("天",A2:B2&amp;"天")-1),"0;;;!0")+TEXT(RIGHTB(SUBSTITUTE(A2:B2,"小时",),2),"0;;;!0")/24)),"[&gt;=1]0天?/24;[&gt;]?/24;"),"/24","小时"),"&#160;&#160;&#160; ","天")<br/>190字符<br/>

dengyf

加等号<br/>=SUBSTITUTE(SUBSTITUTE(TEXT(SUM({1,-1}*TEXT(IF({1;0},LEFT(A2:B2,FIND("天",A2:B2&amp;"天")-1),RIGHTB(SUBSTITUTE(A2:B2,"小时",),2)),"0;;;!0")/{1;24}),"[&gt;=1]0天?/24;[&gt;]?/24;"),"/24","小时"),"&#160;&#160;&#160; ","天")<br/>187字符<br/>