随便随便找个格子输入=text(date(2013,4,27)+time(5,20,19)+time(,(row(A1)-1)*(4+2*rand()),),"yyyy-mm-dd hh:mm:ss")&rept(" ",20)&"编号:"&695+row(A1)下拖填充即可