DATESUBDATE(now(), B3, "d") + "天" + mod(DATESUBDATE(now(), B3, "h"), 24) + "小时" + mod(DATESUBDATE(now(), B3, "m"), 60)
+ "分钟" + mod(DATESUBDATE(now(), B3, "s"), 60) + "秒" //时间差 天时分秒格式
你要的格式
FORMAT(mod(DATESUBDATE(now(), B1, "h"), 24),"#00") + ":" +FORMAT(mod(DATESUBDATE(now(), B1, "m"), 60),"#00")
+ ":" + FORMAT(mod(DATESUBDATE(now(), B1, "s"), 60),"#00")