时期时间整合公式

D列公式：=TEXT(SUM(TEXT(RIGHTB(LEFT($B3,FIND({"天","小","分","秒"},$B3&"天小分秒E列公式：=TEXT(SUM(TEXT(RIGHTB(LEFT($C3,FIND({"天","小","分","秒"},$C3&"天小分秒F列公式：=TEXT(SUM(TEXT(RIGHTB(LEFT($C3,FIND({"天","小","分","秒"},$C3&"天小分秒

说明：

1、C列为手工输入的很不规范的时间值，要求用公式将C列时间转化

为：

D列单位小时，E列单位分，F列单位天、时、分、秒；

2、适用范围：天、时、分、秒仅适用2位数以下。

小分秒")-1),2),"0;;0;\0")/{1,24,1440,86400}),"[h]")

,$C3&"天小分秒")-1),2),"0;;0;\0")/{1,24,1440,86400}),"[m]")

,$C3&"天小分秒")-1),2),"0;;0;\0")/{1,24,1440,86400}),"d天h时m分s秒")