緊握妳首 发表于 2022-2-15 14:20:28

=TEXT(SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分",)-SUBSTITUTE(SUBSTITUTE(A2,"小时",":"),"分",),"")

秤心如意 发表于 2022-2-15 19:35:19

=LEFTB(A1,2)*60+MIDB(A1,FINDB("小时",A1)+4,2)-LEFTB(A2,2)*60-MIDB(A2,FINDB("小时",A2)+4,2) 假设没有超过100小时的

姜国超 发表于 2022-2-18 08:16:21

=SUM(--(SUBSTITUTE(A1:A2,"小",)&"0秒")*{1;-1}*1440)
B2数组三键盘下拉即可

大象没有我帅 发表于 2022-2-19 22:16:30

=(--SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分",":0")---SUBSTITUTE(SUBSTITUTE(A2,"小时",":"),"分",":0"))*1440
或者这样

一年夏秋 发表于 2022-2-20 09:58:03

B2=--TEXT(SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(A1:A2,"小时",":"),"分","")*{1;-1}),"")
B2=SUMPRODUCT((SUBSTITUTE(A1:A2,"小",)&"0秒")*1440,{1;-1})

坤笨笨网红酸奶麻花 发表于 2022-2-21 23:37:12

此公式的前提条件为：小时数不能大于24。

施红燕 发表于 2022-2-24 14:58:38

=SUM(TEXT(SUBSTITUTE(SUBSTITUTE(A1:A2,"小时",":"),"分",),"")*{1;-1})
页: 1 2 [3]
查看完整版本: 时间差问题，谢谢