以下的公式怎么理解?=IF(OR(F2="",G2=""),0,HOUR(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))+MINUTE(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))/60)

来源：学生作业帮助网 编辑：作业帮 时间：2024/08/02 16:16:21
以下的公式怎么理解?=IF(OR(F2="",G2=""),0,HOUR(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))+MINUTE(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))/60)
xݓkPR$,knn~4ն{&+8{䦷5[:>9`NdZT;"]XMN}OrsV;=C'guwB-(m+B˨4.f%O4˪ 7~_$M.fo-3م?u^4WtOTԼh^GhRl1V2RRcf1T^aLC+ .fq5%:D(` NF\x!4̢DB48 A78 I Qְ&,Xݱ|¥X1`,$ax (o,#,Ǒ.a.h.k{-R;w>~?kțm3*tCw9wNoxCܣ/^{zqi0խA=:%> (kJMҮϷA!#jOO/h,Sډ(Bf)&zn0dSN!!c-m5|/

以下的公式怎么理解?=IF(OR(F2="",G2=""),0,HOUR(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))+MINUTE(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))/60)
以下的公式怎么理解?

=IF(OR(F2="",G2=""),0,HOUR(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))+MINUTE(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))/60)

以下的公式怎么理解?=IF(OR(F2="",G2=""),0,HOUR(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))+MINUTE(TIME(LEFT(G2,2),RIGHT(G2,2),0)-TIME(LEFT(F2,2),RIGHT(F2,2),0))/60)
简单讲：
如果F2或G2任意1个为空白,就显示0
反之就计算G2 F2 之间的小时数是多少?

你这个公式写复杂了,好像不对吧?
简化为：
=IF(OR(G2="",F2=""),0,HOUR(G2-F2)+(MINUTE(G2-F2)/60))
结果4.27小时