excel生成某一段时间内的随机值
=TEXT(RAND()*("2018/8/31"-"2018/8/1")+"2018/8/1","yyyy/m/d")&TEXT(RAND()*("22:59:00"-"9:00:00")+"10:0"," h:mm:ss")
excel生成某一段时间内的随机值
=TEXT(RAND()*("2018/8/31"-"2018/8/1")+"2018/8/1","yyyy/m/d")&TEXT(RAND()*("22:59:00"-"9:00:00")+"10:0"," h:mm:ss")