N2单元格公式如下：=IF(L2="","",TEXT(L2+TIME(M2,0,0),"YYYY/M/D h:m:s"))或者：=IF(L2="","",TEXT(L2+TIME(M2,0,0),"M/D/YY h:m:s"))这两个公式只是在显示的格式上有区别。
