不要不要
发表于 2022-1-14 09:45:33
=EVALUATE(SUBSTITUTE(SUBSTITUTE(A1,"小时","*60+"),"分",))-EVALUATE(SUBSTITUTE(SUBSTITUTE(A2,"小时","*60+"),"分",))
WPS的话直接用。。。EXCEL的话定义名称即可！
回不去的故乡
发表于 2022-1-15 02:28:27
=TEXT(SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分",)-SUBSTITUTE(SUBSTITUTE(A2,"小时",":"),"分",),"")
途徒
发表于 2022-1-15 09:18:38
=LEFTB(A1,2)*60+MIDB(A1,FINDB("小时",A1)+4,2)-LEFTB(A2,2)*60-MIDB(A2,FINDB("小时",A2)+4,2) 假设没有超过100小时的
白绿蓝
发表于 2022-1-18 13:56:16
=SUM(--(SUBSTITUTE(A1:A2,"小",)&"0秒")*{1;-1}*1440)
B2数组三键盘下拉即可
李班长
发表于 2022-1-21 20:55:25
=(--SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分",":0")---SUBSTITUTE(SUBSTITUTE(A2,"小时",":"),"分",":0"))*1440
或者这样
痴心的人
发表于 2022-1-25 15:14:36
B2=--TEXT(SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(A1:A2,"小时",":"),"分","")*{1;-1}),"")
B2=SUMPRODUCT((SUBSTITUTE(A1:A2,"小",)&"0秒")*1440,{1;-1})
梁惠军
发表于 2022-1-25 17:48:41
此公式的前提条件为：小时数不能大于24。
刘冲
发表于 2022-1-25 22:05:51
=SUM(TEXT(SUBSTITUTE(SUBSTITUTE(A1:A2,"小时",":"),"分",),"")*{1;-1})
甄斌
发表于 2022-1-26 04:59:00
相隔多少分钟
壹贰叁石头人
发表于 2022-2-10 14:53:31
=EVALUATE(SUBSTITUTE(SUBSTITUTE(A1,"小时","*60+"),"分",))-EVALUATE(SUBSTITUTE(SUBSTITUTE(A2,"小时","*60+"),"分",))
WPS的话直接用。。。EXCEL的话定义名称即可！