Excel中怎样把用一个公式把下面天时分秒转换成小时?
发布网友
发布时间：2022-04-23 05:32
共2个回答
热心网友
时间：2023-10-16 14:26
A1:
=(IFERROR(LEFT(A1,FIND("天",A1)-1),0)+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(RIGHT(A1,LEN(A1)-IFERROR(FIND("天",A1),0)),"小时",":"),"分钟",":"),"秒","")," ",""))*24
热心网友
时间：2023-10-16 14:26
=IF(LEN(A1)-12>0,LEFT(A1,LEN(A1)-12)*24,0)+IF(LEN(A1)-9>0,LEFT(RIGHT(A1,11),2),0)+IF(LEN(A1)-6>0,LEFT(RIGHT(A1,7),2)/60,0)+LEFT(RIGHT(A1,3),2)/3600
如果只需要整小时，那么
=IF(LEN(A1)-12>0,LEFT(A1,LEN(A1)-12)*24,0)+IF(LEN(A1)-9>0,LEFT(RIGHT(A1,11),2),0)
