|
本帖最后由 suzhouy2003 于 2015-11-11 23:47 编辑
201502函初:A10
答题1 =TEXT(B3,"")-TEXT(A3,"")&"秒" 下拉
答题2 =INT(LEFT(C3,LEN(C3)-1)/60)&"分钟" 下拉
答题3 =TEXT(LEFT(D3,LEN(D3)-1)/60,"0.00")&"小时" 下拉
答题4 =TEXT(ROUNDDOWN(LEFT(C3,LEN(C3)-1),-4),"[DBnum2]")&"秒" 下拉
答题5 =TEXT((LEFT(C3,LEN(C3)-1))/24/60/60,"d天hh小时mm分钟ss秒") 下拉 |
|