用excel这样解决的 ，搬砖：=IF(C2=24,"24:00-01:00",IF(C2=23,"23:00-24:00",IF(C2=22,"22:00-23:00",IF(C2=21,"21-22点",IF(C2=20,"20:00-21:00",IF(C2=19,"19:00-20:00",IF(C2=18,"18:00-19:00",IF(C2=17,"17:00-18:00",IF(C2=16,"16:00-17:00",IF(C2=15,"15:00-16:00",IF(C2=14,"14:00-15:00",IF(C2=13,"13:00-14:00",IF(C2=12,"12:00-13:00",IF(C2=11,"11:00-12:00",IF(C2=10,"10:00-11:00",IF(C2=9,"9:00-10:00",IF(C2=8,"8:00-9:00",IF(C2=7,"7:00-8:00",IF(C2=6,"6:00-7:00",IF(C2=5,"5:00-6:00",IF(C2=4,"4:00-5:00",IF(C2=3,"3:00-4:00",IF(C2=2,"2:00-3:00",IF(C2=1,"1:00-2:00"))))))))))))))))))))))))