君不悔 发表于 2021-11-17 15:47:00

时间差问题，谢谢

建彬 发表于 2021-11-21 01:24:16

相隔多少分钟

葡挞 发表于 2021-11-27 15:40:13


=EVALUATE(SUBSTITUTE(SUBSTITUTE(A1,"小时","*60+"),"分",))-EVALUATE(SUBSTITUTE(SUBSTITUTE(A2,"小时","*60+"),"分",))
WPS的话直接用。。。EXCEL的话定义名称即可！

天启科技 发表于 2021-12-5 06:22:42

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

魏嘉澍 发表于 2021-12-10 11:17:44

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

小丑鸭 发表于 2021-12-18 20:04:04

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

宋某某 发表于 2021-12-20 06:09:05

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

三国演义 发表于 2021-12-23 05:36:56

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

红汤焖肉吧 发表于 2022-1-9 05:14:40

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

中原之路 发表于 2022-1-10 08:45:56

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