Question

excel中怎样换算时间几小时几分钟几秒换算成一共多少秒？并求和

excel中怎样换算时间几小时几分钟几秒换算成一共多少秒？并求和？

Answer 1

B2=SUBSTITUTE(SUBSTITUTE(A2,"分",":"),"秒","")*60*24 下拉 如有问题把格式设成常规
求和就直接用sum(b2:b100)

Answer 2

=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(A1:A200,"分",":"),"秒",))*86400&"秒"