excel中如何在一个单元中设置两个时间中间要加斜杠

运行效果图如下：A2单元格输入公式：=IF(RANDBETWEEN(5,6)=5,"5"&":"&RANDBETWEEN(45,59),"6"&":"&TEXT(RANDBETWEEN(1,15),"00"))&" / "&IF(RANDBETWEEN(10,11)=10,"10"&":"&RANDBETWEEN(45,59),"11"&":"&TEXT(RANDBETWEEN(1,15),"00"))B2单元格输入公式：=IF(RANDBETWEEN(11,12)=11,"11"&":"&RANDBETWEEN(45,59),"12"&":"&TEXT(RANDBETWEEN(1,15),"00"))&" / "&IF(RANDBETWEEN(4,5)=4,"4"&":"&RANDBETWEEN(45,59),"5"&":"&TEXT(RANDBETWEEN(1,50),"00"))根据你需要的范围调整你需要的随机范围修整公式就可以