Question

I列的值怎样用函数算出来啊

Answer 1

I2输入：

=TEXT(DATE(MID(H2,7,4),MID(H2,1,2),MID(H2,4,2))+RIGHT(H2,LEN(H2)-FIND(" ",H2)-1)-(DATE(MID(G2,7,4),MID(G2,1,2),MID(G2,4,2))+RIGHT(G2,LEN(G2)-FIND(" ",G2)-1)),"[HH]:MM:SS")

好了.这样就好了