EXCEL 时间求和怎么求 求公式

Question

如题所述

Answer 1

=TEXT(SUBSTITUTE(A1,"小","")+SUBSTITUTE(A2,"小",""),"h小时m分s秒")追问

A1：A2 怎么表达

追答

=TEXT(SUMPRODUCT(SUBSTITUTE(OFFSET(A1,,,COUNTA(A1:A8)),"小","")*1),"h小时m分s秒")

Answer 2

=TEXT(SUM(--SUBSTITUTE(A1:A2,"小",)),"[h]小时m分s秒")数组追问

公式有错误啊

追答

怎么有误？你数组回车（CTRL+SHIFT+ENTER)了吗？